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

Home -> Community -> Usenet -> c.d.o.misc -> Oracle Order By Clause

Oracle Order By Clause

From: <greco_at_freenet.macatawa.org>
Date: 1998/02/07
Message-ID: <886726729.562036738@dejanews.com>#1/1

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 Usenet
Received on Sat Feb 07 1998 - 00:00:00 CST

Original text of this message

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