Archives of the TeradataForum

Message Posted: Wed, 23 Mar 2011 @ 11:03:48 GMT

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

Hi ,

I want to know how to tune a query which is taking very long time. Usually I ma doing following

1) checking explain plan

2) collect stat on Index and other columns which are used in Joining and where condition.

Many time after doing it I am able to tune but sometime I have not able to do any imporvemnt Can anyone tell me what extra we can do?

Thanks,

Samikkumar Shah

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