Archives of the TeradataForum

Message Posted: Thu, 10 Jun 2004 @ 16:16:06 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Prasanna,

query optimisation is a convoluted process with many factors to take account of.

It is hard to optimise a query without all the other information to hand. You need to look at the explain to identify the join plan, identify any redistributions or product joins, use of indices, data skewing and the state of the target table are all things to bear in mind.

The teradata Performance Optimisation manual covers a lot of this stuff.

Cheers,

Tris Bayliff.

	<Prev	Next>		<<First	<Prev	Next>	Last>>