In general, how do you optimze any sql in teradata?
- 1 Answers
- 1118 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kumar Pal Singh
Optimizing SQL in Teradata can be achieved through several methods:n1. Using appropriate indexesn2. Avoiding SELECT * FROM statements and instead specifying columns explicitlyn3. Using sort-merge joins whenever possiblen4. Limiting the amount of data returned by using WHERE clauses effectivelyn5. Minimizing the use of subqueriesn6. Partitioning tables based on access patterns
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is node? How many nodes and amps used in your previous project?
