Re: Oracle Order By Clause

I write SQL inside of Perl scripts. With this much load on the server, I would retrieve them without the sort and do the sort in my script.

Also, I would check to see if your table design is optimal. That's a lot of tables to join. How many columns do you ask for in this query?

If you want to email me your SQL statement I'll take a look at it and give you any suggestions I might come up with.

Greg Teets
teetshd_at_ucbeh.san.uc.edu

On Sat, 07 Feb 1998 06:41:15 -0600, greco_at_freenet.macatawa.org wrote:

>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