Re: Index strategy for huge partitioned table

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Wed, 23 Aug 2006 01:30:51 GMT
Message-ID: <fdOGg.2080$yO7.1199@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?

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. Received on Tue Aug 22 2006 - 20:30:51 CDT