Archives of the TeradataForum

Message Posted: Tue, 19 Feb 2008 @ 14:42:07 GMT

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

Are there current statistics on the fast loaded 'key table', the one you say you drop and re-create?

If so, are they current every day with this query runs? Could it be a timing issue? I've seen cases were the query runs before the stats job 'sometimes', which could cause your issue. When you come along and look a few minutes later, the stats are 'up to date'.

If there are no stats, it could be due to random amp sampling and skew.....when you drop the table and recreate it, it will have a different tableid, which would probably result in another AMP being sampled for stats, and if there's skew (or it's a small table and not all AMPS are populated), it's the luck of the draw whether the AMP is representative of the tables data. Collect appropriate stats if there aren't any.

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