Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: mystic query (???)
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
![]() |
![]() |