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

Home -> Community -> Usenet -> c.d.o.misc -> Re: mystic query (???)

Re: mystic query (???)

From: <vuht2000_at_yahoo.com>
Date: 7 May 2004 08:20:20 -0700
Message-ID: <c9cd729c.0405070720.7aad7bc2@posting.google.com> 





Oh but when I recreated the tables on my PC and rerun the query, it
still uses indexes and runs fast. While on the server even when
indexes are used, it still runs forever ?? That's the single query
that cause me problem, all others run OK


> 

> Cost Based Optimizer (CBO) requires two things:

> 

> 1. Read the documentation

> 2. Statistics generated using DBMS_STATS.

Received on Fri May 07 2004 - 10:20:20 CDT












Original text of this message













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