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

Home -> Community -> Usenet -> c.d.o.server -> Age old question.. count(*), count(id) or count(1) faster ?

Age old question.. count(*), count(id) or count(1) faster ?

From: EnderW <ender29_at_my-deja.com>
Date: 2000/06/19
Message-ID: <8ilu69$ip$1@nnrp1.deja.com>#1/1

Hi,
 No flames.. Have a quick question. I thought this matter be settled but it came up again. Is select count(*) from table faster than select count(id) from table or select count(1) from table faster ? I think all should be equal. ( id is an indexed column by itself in table). I did an explain plan and it came up same for those cases. Or is it not ? am I missing something ? Thnkx in adv.

--
Ender Wiggin


Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Mon Jun 19 2000 - 00:00:00 CDT

Original text of this message

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