Re: Oracle hints and Crystal Reports

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

Alternatively ... put your SQL into a stored procedure or view in the database.

-- 
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)