Re: oracle equivalent of teradata's sparse index

  • From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
  • To: dd.yakkali@xxxxxxxxx
  • Date: Mon, 2 Aug 2010 18:43:43 -0500

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: