Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Brainstorming
28 Nov 2002 01:02:43 -0800, ls cheng said (and I quote):
>
> My only solution (occured to me) was partition the table by some date
> column and convert all indexes into global indexes (including the
> partition column index) and drop the corresponding partitions
>
>
Akshally, I'd go with local indexes. He most likely processes daily or weekly. Which means he can use the main local index for the optimizer to locate itself within the right partition(s) and then blast away with the other local indexes if needed. The trick is to individually analyze each local index: after that, even the 8.0 optimizer will pick things from the right spot. There is always hinting, of course... :)
-- Cheers Nuno Souto nsouto_at_optusnet.com.au.nospamReceived on Thu Nov 28 2002 - 04:53:23 CST