Slow performance with SQL Script / TOAD

[Nro]

One of my client have problem with one of their report. They use a SQL Server script and the running time is about 1:45 + hrs. They have the same script running in Toad, and take the same time.

In Toad, they found that the command :

alter session set "_optimizer_connect_by_cost_based" = true;

The query is done in 15 sec. My client want to put this command in Crystal, but it does not seem to work. Is there an other way?

Thanks

Nro

 

[beltmanjr]

Is this a command you use in your SQL? Coz I think it is something you set on the server. Perhaps even permanent if you like. But I dont see an option for crystal to do so, unless it can be set in the connection parameters.

You could also consider looking at the query and try to split it up in such manner that you create some sub reports.

I did this with a query that took ages in sql developer and even longer in crystal. After moving parts into subreports the report took like 5 minutes to run!