Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX Question

Re: INDEX Question

From: <andrewf_at_jaredgroup.com>
Date: Mon, 15 Feb 1999 19:27:03 GMT
Message-ID: <7a9se1$vqd$1@nnrp1.dejanews.com> 





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












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US