Re: Oracle hints and Crystal Reports

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 04 Feb 2004 15:24:19 -0600
Message-ID: <blo220picgo2h1g3fd492ivthaoqhlhivu@4ax.com>

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