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 -> optimizer mode

optimizer mode

From: Mark <mbwn_at_inwind.it>
Date: Sun, 16 Jun 2002 19:35:38 GMT
Message-ID: <eM5P8.24766$j65.597564@twister1.libero.it>


I imported a db schema to a 7.3.4 db and the optimizer don't do what i want. I used a rule-based optimizer mode, and i told that on the init*.ora. I tried deleting statistics with
ANALYZE TABLE table DELETE STATISTICS;
I tried rebuilding indexes
 but it doesnt like to use the index as it usually do in the other schema.

Is there something wrong?

best regards Received on Sun Jun 16 2002 - 14:35:38 CDT

Original text of this message

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