Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Oracle Order By Clause
I have a SQL call that joins 10 tables. Without the Order By clause I get results fast. With it, I have to wait upwards of 3 hours for results. Is it better to sort the data via a MergeSort or Qsort after retrieving it without the Order By or is there some proper way to create SQL statements when the Order By is used?
Thanks in advance for the help.
MG
-------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to UsenetReceived on Sat Feb 07 1998 - 00:00:00 CST
![]() |
![]() |