Thread: Sort question ! ! !

Sort question ! ! !

From
jennifer llerena
Date:
hi everyone!

I want to know if the sort process can be improve.
Or what parameters should I check if it`s working with
the best performance possible.

thanks a lot!

Jennifer Llerena

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

Re: Sort question ! ! !

From
"A. Kretschmer"
Date:
am  Thu, dem 07.12.2006, um  6:14:06 -0800 mailte jennifer llerena folgendes:
> hi everyone!
>
> I want to know if the sort process can be improve.
> Or what parameters should I check if it`s working with
> the best performance possible.

Do you have a index on that column? Which data-typ is this column?


Andreas
--
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47215,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   http://wwwkeys.de.pgp.net

Re: Sort question ! ! !

From
"Daniel T. Staal"
Date:
On Thu, December 7, 2006 9:14 am, jennifer llerena said:
> hi everyone!
>
> I want to know if the sort process can be improve.
> Or what parameters should I check if it`s working with
> the best performance possible.
>
> thanks a lot!
>
> Jennifer Llerena

Run an 'Explain Analyze' on the queries you want to speed up, and see what
is taking the time.  Then you can look to see if reformulating the query
or putting in a new index may be helpful.

Daniel T. Staal

---------------------------------------------------------------
This email copyright the author.  Unless otherwise noted, you
are expressly allowed to retransmit, quote, or otherwise use
the contents for non-commercial purposes.  This copyright will
expire 5 years after the author's death, or in 30 years,
whichever is longer, unless such a period is in excess of
local copyright law.
---------------------------------------------------------------