Performance issues making a SELECT with ORDER BY (DESC)
From: PPN <ppn_at_mederic.fr>
Date: 12 Jul 2002 04:32:34 -0700
Message-ID: <6f6a7f59.0207120332.3ad21aef_at_posting.google.com>
Date: 12 Jul 2002 04:32:34 -0700
Message-ID: <6f6a7f59.0207120332.3ad21aef_at_posting.google.com>
Hello.
I am currently using Oracle 8i on an 8 processor Sun machine running
Solaris, and I'd like to know if there is any loss of performance
when, instead of making an ORDER BY in my SELECT, I use ORDER BY ...
DESC on the very same columns.
I order on two columns, each of these having its own index, and I join
the table with 4 other tables.
My tables do not have enough data to make relevant tests (each table
has less than 1.000 lines...).
Thanks for answering.
P.
Received on Fri Jul 12 2002 - 13:32:34 CEST