Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle hints and Crystal Reports
kplasun_at_hotmail.com (kris p) wrote:
>Hello everybody,
>
>I had to use Oracle hints to make a Crystal Report SQL query go
>faster but CR erases anything before the WHERE clause. Is it
>possible to tell Oracle beforehand what hints to use on the
>succeeding query?
>
>TIA,
>kristoff plasun
Rather than rely on hints, tune the Sql so the CBO will work efficiently. Analyze the table(s) then try the Sql in SqlPlus with Explain Plan to see what is happening. Received on Wed Feb 04 2004 - 15:24:19 CST
![]() |
![]() |