Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX Question
Can you provide more detail? How big is the result set? How slow is the
execution? What's the index and what's the plan?
From the info available, if a SORT is the reason of slowness, you may want to tune the system to better support SORT. But a better solution may be to rewrite your SQL to get rid of Union.
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 15 1999 - 13:27:03 CST