SQL Command makes report run slow

[ianoctdec]

Hi everyone,
I am using Crystal Reports 10, Oracle db with ODBC connection. I created a report based on a SQL command and is running very slow. Is this a known issue with Crystal Reports 10? Is there anything to do to improve the speed performance?

Thank you for taking the time to answer to my post.
Dana

 

[cmmrfrds]

It is mostly likely the query. I have written about 50 different SQL command objects to Oracle through the Oracle OLEDB Provider. These all perform comparable on Toad or ISQL Plus. A complex query with aggregation using large tables will take a while to finish.
Is this a simple query?
Have you run it in another interface, like Toad?
Define slow.
What version of Oracle?