oracle equivalent of teradata's sparse index
From: dd yakkali <dd.yakkali_at_gmail.com>
Date: Mon, 2 Aug 2010 16:36:17 -0700
Message-ID: <AANLkTi=g7x98GPaz+DCTW36tSXxruvsXKuCFZxDF1q8Q_at_mail.gmail.com>
hello dbas,
Date: Mon, 2 Aug 2010 16:36:17 -0700
Message-ID: <AANLkTi=g7x98GPaz+DCTW36tSXxruvsXKuCFZxDF1q8Q_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 02 2010 - 18:36:17 CDT