Archives of the TeradataForum

Message Posted: Thu, 11 Aug 2005 @ 17:55:53 GMT


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

Subj:		Re: Primary Index vs Single Condition

From:		Dieter Noeth

Phil.Oldfield wrote:

We have a large (150 Gb) transaction table with a primary index of transaction_no(decimal(18,0)) - Regular Stats collected

I am trying to retrieve last 13 weeks of data from this table. This is about 25% of all the rows

Sounds like a good candidate for a partitioned table...

Dieter


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

Archives

2005 Indexes

Last Modified: 15 Jun 2023