Re: oracle equivalent of teradata's sparse index
- From: Andrew Kerber <andrew.kerber@xxxxxxxxx>
- To: dd yakkali <dd.yakkali@xxxxxxxxx>
- Date: Mon, 2 Aug 2010 21:32:13 -0500
Hmmm. I dont know if query_rewrite_enabled would handle that transparently
or not, but it might be worth finding out.
On Mon, Aug 2, 2010 at 8:18 PM, dd yakkali <dd.yakkali@xxxxxxxxx> wrote:
> 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.'
>>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
