Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
SQL Precedence
Craig322, Your second note says that you insert daily ??? into your sales table??? What is your specific problem? I guess your real problem may be the aggregation / joins to build the summaries. Are you rebuilding your summary tables monthly also or weekly / daily? 14 hours doesn't sound bad...- ek123795
- Post #9
- Forum: NCR: Teradata
-
SQL Precedence
Craig322, Sorry hit the enter key to quickly. Also would need current processing time, # of system nodes, chip speed, target row size, fallback or not. These are just the basics, but will get me close enough to validate your range of performance.- ek123795
- Post #7
- Forum: NCR: Teradata
-
SQL Precedence
Craid322, If you can you provide more information on you situation, we may be able to help more. I am a Senior Consultant for Teradata. How big is the target detail table? How many rows are you adding per period? You may not want to drop secondary indexes, load, recreate SI, and recollect...- ek123795
- Post #6
- Forum: NCR: Teradata
