Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Performance Brainstorming

Re: Performance Brainstorming

From: Nuno Souto <nsouto_at_optushome.com.au.nospam>
Date: Thu, 28 Nov 2002 21:53:23 +1100
Message-ID: <3de5f864$0$15986$afc38c87@news.optusnet.com.au>


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.nospam
Received on Thu Nov 28 2002 - 04:53:23 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US