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?