Andrew, thanks for the reply, but the queries have to be segregated to go against the mview in certain cases versus table in other cases. This calls for code changes and you know how any thing to change code goes through a lot of red tape. thanks Deen On Mon, Aug 2, 2010 at 4:43 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote: > 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.' >