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