Query optimization techniques?

Database

Query optimization techniques?

what are the various query optimization techniques in Teradata?
2 REPLIES
N/A

Re: Query optimization techniques?

just give us some clear picture about what kinda optimization you need...so that it will be easy to suggest.

Re: Query optimization techniques?

hi

Actually it was an interview question asked to my friend.
so i just wanted to know if there were any specific techniques to optimize the query in teradata.
From the things that i have been studying it was only mentioned that the optimizer does this. and we only have a choice of writing a join or subquery.
Besides that are there any general methods to optimize the query?