Help - Search - Members - Calendar
Full Version: Cursor performance
Oracle DBA Forums > Oracle > Oracle Forum
testoracle
Hi

I have three queries- each involving subqueries. I have created three cursors- one for each query. But now I am in dilemma of replacing them with single cursor. And my query will be - all the three queries unioned together. please suggest options for me- which is the best approach?

Thanks
burleson
>> which is the best approach?

Me, I like to replace subqueries with standard joins whenever possible . . . .

I would use UNION with a single cursor.

Afterall, why have additional overhead, if it's not necessary?
SteveC
Let's begin to guess what your code looks like or does. Umm, drawing a blank here. Your question is about the same degree of detail as this:

"My query takes a long time, can anyone help?"

If someone were to ask you that, what would your guess be as to the problem?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.