Re: oracle equivalent of teradata's sparse index

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

Andrew, thanks for the reply, but the queries have to be segregated to go
against the mview in certain cases versus table in other cases. This calls
for code changes and you know how any thing to change code goes through a
lot of red tape.

thanks
Deen

On Mon, Aug 2, 2010 at 4:43 PM, Andrew Kerber <andrew.kerber@xxxxxxxxx>wrote:

> 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: