Archives of the TeradataForum

Message Posted: Wed, 03 Aug 2011 @ 14:20:08 GMT

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

Thank you all.

I just wanted to know if there will any performance wise difference between collecting stats on table and collecting stats on individually in sequence.

Actually we have a job in production which failed with AMP skew in a 'Collect stats' query. (which is quite rare scenario for us)

That table is having stats defined on 5 columns.

I was just wondering if replacing this statement with 5 individual query will make any performance improvement or prevent it from failing.

PLease Help.

Thanks

Sukul

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