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: Optimizer puzzle: unnecessary full index scan

Re: Optimizer puzzle: unnecessary full index scan

From: bonminh lam <hansmayer1962_at_hotmail.com>
Date: 16 May 2002 03:07:30 -0700
Message-ID: <3c6b1bcf.0205160207.69d309aa@posting.google.com> 





Hi,



sorry that I did not come around to reply to this thread earlier. In
the end I chose the easy but not so elegant way out by using an index
hint on the production machine. That brought the execution time for
the statement back to minutes.
Received on Thu May 16 2002 - 05:07:30 CDT












Original text of this message













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