> Our "DBA" stated that partitioning the indexes into local indexes would be
> a
> "maintenance nightmare". With a partitioned table of this size, is there
> any reason why the indexes themselves should not also be partitioned (I'm
> trying to come up with a reason why the DBA seems so against it)? Should
> ALL be partitioned or just a few be partitioned?
>
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.
Received on Tue Aug 22 2006 - 18:47:37 CDT
