Archives of the TeradataForum

Message Posted: Tue, 21 Feb 2006 @ 20:57:10 GMT

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

Unless you have a secondary index on the acct_id, there would be a full table scan on the table (or partition of the table with PPI).

FYI - Typically, you will not be creating PIs with a timestamp as a column in the Primary Index (remember that this is not a PK).

Jeff Pankow

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