Re: Index strategy for huge partitioned table

From: Bob Jones <email_at_me.not>
Date: Wed, 23 Aug 2006 03:59:53 GMT
Message-ID: <ZoQGg.3285$q63.1422@newssvr13.news.prodigy.com>

"Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote in message news:fdOGg.2080$yO7.1199_at_newssvr14.news.prodigy.com...
>> Your DBA has brought a whole new meaning to "maintenance nightmare".
>> Local
>> indexes require less maintanence than global indexes. In most cases, you
>> would want to use local.
>>
>>
>
> I'm trying to figure out what his meaning is. From what you wrote I'd be
> under the impression that I'd want to make just about all - or ALL - the
> indexes local?
>

In most cases.

> Sorry for asking so many questions but I know that when I make my
> recommendations I may have an uphill battle to get any of them actually
> implemented. I just want to be able to have as much supporting
> "documentation" as I can.
>
>

You can find documentation in the manuals. I know how hard it is to change people's mind sometimes. Good luck. Received on Tue Aug 22 2006 - 22:59:53 CDT