Hi All, I have a simple list report which i have joined at the report level using master detail relationship. When i paste the query in TOAD i get the data in less than 20 seconds. However, in Cognos the report runs and runs and runs without any output. I have tried changing the processing option to Database Only, but it doesn't work. Any ideas why this is happening? Please let me know.
Thanks!!
try creating simple report with just one or two columns and then try to run, see how long it will take. check your database connection, try and use native connection type.
Have you tried pasting the SQL you are using in TOAD into a query, and use the "Pass-Through SQL" option. This should pass everything directly to TOAD.