Have a look into query rewrite functionality. You can save the "good" plan
for later use with the query generated by a 3rd party soft.
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"kris p" <kplasun_at_hotmail.com> a écrit dans le message de
news:db13b49.0402041242.4635a58_at_posting.google.com...
> 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
Received on Wed Feb 04 2004 - 14:53:48 CST
