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 -> Different execution plans for similar schemas on same query

Different execution plans for similar schemas on same query

From: Leigh Gold <intan_5ee_at_yahoo.com>
Date: Thu, 16 May 2002 13:23:12 -0600
Message-ID: <ac10r6$egj$1@news3.cadvision.com> 





Using the same query on two similar schemas (exp/imp) on 2 similar server


(Win NT), I encountered 2 different execution plans, one uses full table

scan (on oracle 8.1.7) and the other index scan (8.1.6). The different
between these 2 schemas are that 1 run on 8.1.6 and the other 8.1.7.



Have the optimizer changed with 8.1.7?



The db_block_size is the same, both are analyzed with same sample size


(33%).  What else should I check?




Thanks,


Leigh
Received on Thu May 16 2002 - 14:23:12 CDT












Original text of this message













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