| Query is Fast But report is slow [message #225994] |
Thu, 22 March 2007 04:07  |
pankaj Rathee
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
Hi,
I have a query which is very fast when i run it in Toad or SQL Plus but when i am running the report based on that query in report builder 6i it is either taking a long time to complete or erroring out with temp table space full error.I am not using any formula columns or program units in this report.It is taking 2 sec in Toad and SQL Plus but 25-30 minutes in report builder.I am attaching the query as attachment.
|
|
|
|
|
|
| Re: Query is Fast But report is slow [message #226949 is a reply to message #226009] |
Tue, 27 March 2007 00:24  |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
|
Could it be that in TOAD you're only retrieving the first n rows? Because Reports doesn't tend to use more temp tablespace than the query itself... So, like AT mentioned, tune your query first.
|
|
|
|
|
|
| Re: Query is Fast But report is slow [message #227331 is a reply to message #227093] |
Wed, 28 March 2007 01:02 |
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
|
Senior Member |
|
|
Hm, maybe some reports expert can explain this? (I can't...) Littlefoot, do you have any suggestions?
Still, I would examine the qeury in the report closely because like I said, tools (like reports) don't use temp tablespace, so it's just about impossible that the query is fast in SQL and generates a temp tablespace error in reports.
The report is run under the same user? Same database? Same tables? No views in between or something?
|
|
|
|
|
|
| Re: Query is Fast But report is slow [message #251152 is a reply to message #225994] |
Thu, 12 July 2007 09:25 |
prasad.viji
Messages: 12
Registered: December 2005
Location: pondicherry
|
Junior Member |
|
|
Dear,
I am also faced the same problem,that is , the data are more larger the nested query does take the time for 25 - 30 minutes ,so try to tune up the query and insert the record into the temporary table and in ur report builder use the temporary table
note : before calling the report do all this procedure
Thanks
Prasad.D
|
|
|
|
| Re: Query is Fast But report is slow [message #296927 is a reply to message #251152] |
Tue, 29 January 2008 08:56 |
maxapp
Messages: 2
Registered: January 2008
|
Junior Member |
|
|
We've had a similar problem from many our customers.
The solution is very simple (if the problem is the same). Try to do an update (not real, for example rewrite a comma) to the report query, rebuild the rep and try again.
After that our query has become fast in the report too.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
