List:General Discussion« Previous MessageNext Message »
From:Martin Ramsch Date:August 16 1999 7:36pm
Subject:Re: is an ORDER BY faster if the column is indexed?
View as plain text  
On Mon, 1999-08-16 12:21:11 -0700, Jann Linder wrote:
> I know 'select * from * where abc = x' is faster if abc is
> index...however is an ORDER BY abc faster if abc is indexed?

not really the answer, but a strong indicator: in some small test I
just did, there's no time difference.

Regards,
  Martin
-- 
Martin Ramsch <m.ramsch@stripped> <URL: http://home.pages.de/~ramsch/ >
PGP KeyID=0xE8EF4F75 FiPr=52 44 5E F3 B0 B1 38 26  E4 EC 80 58 7B 31 3A D7
Thread
is an ORDER BY faster if the column is indexed?Jann Linder16 Aug
  • Re: is an ORDER BY faster if the column is indexed?Martin Ramsch16 Aug