oracle equivalent of teradata's sparse index

  • From: dd yakkali <dd.yakkali@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 2 Aug 2010 16:36:17 -0700

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

Other related posts: