The very thought of Normalizing my teradata database, prompts me to ask a few questions
say i have a product, sales & customer tables in third normalized form
and i run multiple queries in parallel which use the above tables
Would Tearadata AMP’s get over worked leading to an increased execution time if many of my SQL's refer to the same table at same time?
ex: sales table being referred by 3 different sql queries at same time
Any insight on this would be helpful
Increased execution time won't depends on running multiple queries on same table though it depends on running multiple queries (independent on table).
Even if all the 3-4 queries doing full table scan on same table Sales, execution time won't get increased as Teradata handles this scenario through "Synchronized Scanning" but if there is already load on Database becasue of different users then execution time will increase.
Kindly let me know if my understanding is wrong.