Re: oracle equivalent of teradata's sparse index

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.'

Other related posts: