Archives of the TeradataForum

Message Posted: Thu, 08 Oct 2009 @ 19:59:11 GMT

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

I would review DBQL Object Log table and then drop stats in a phased manner.

I have seen sites collecting stats on Bizarre columns such as Quantity, Amount, Some Time Stamps, Large Character fields and so forth.

I don't believe they add much value but you could check the Explain plan and drop them too.

Thanks,

Vinay Bagare

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