Query runs quickly in Oracle SQL Developer, but slowly in SSRS 2008 R2?

Posting the query may help. Your DBA should be able to identify the session in a view called v$session, and the columns EVENT and WAIT_CLASS should give an indication of what is happening on the Oracle end. He would also be able to identify the SQL (SQL_ID from v$session) and use that in a SELECT * FROM TABLE(DBMS_XPLAN.

DISPLAY_CURSOR(sql_id)) to determine the plan. If it is a development/test instance, see if he will grant you permissions to do that yourself if he (or she) is busy.

Added query. I'll look into your other suggestions. – ErikE Jan 25 at 18:07 Thank you.

Seeing the execution plan (COMPLETELY different than the one I get from SQL Developer) proved that indeed was the problem. Now I'm deep in the woods figuring out how to force the execution plan I need. Sigh.

– ErikE Feb 6 at 21:43 P.S. Actually, I struggled and struggled and never could get it to work reliably until I put the results of the main table access into a GLOBAL TEMPORARY TABLE and then joined to that in the rest of the query. /*+MATERIALIZE*/ didn't seem to help, either. Some of this is still a mystery to me.

A painful, painful mystery. The hours I've wasted on this... – ErikE Feb 6 at 23:44.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.