Well, you could create a materialized view of the previous days data and index that. On Mon, Aug 2, 2010 at 6:36 PM, dd yakkali <dd.yakkali@xxxxxxxxx> wrote: > hello dbas, > > Some one asked me that teradata can create index for only a subset of rows > of a table. We have a huge table (5 billion) which is for few months of data > but the data for most part is accessed for yesterday. So the question is: is > there any way to create index only for yesterday. > > Google did not come up wth any hits. > > thanks > Deen > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'