Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: mystic query (???)
vuht2000_at_yahoo.com wrote:
> 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.
Irrelevant. That you can avoid good practices in some cases has no meaning or value.
Not everyone involved in a plane crash dies. But that is hardly a recommendation to crash-land airplanes.
Do it correctly and see if the problem goes away.
-- Daniel Morgan http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp damorgan_at_x.washington.edu (replace 'x' with a 'u' to reply)Received on Fri May 07 2004 - 10:41:14 CDT
![]() |
![]() |