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)