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 -> Re: Would Oracle use index on count(*)?

Re: Would Oracle use index on count(*)?

From: Brett Neumeier <random_at_nospam.com>
Date: 15 Apr 1998 16:25:16 GMT
Message-ID: <6h2n1c$coe$1@eve.enteract.com> 





Jim Morgan <jimmorgan_at_csi.com> wrote:


> Also, the discussion on using count(column) to force using the primary key


> also applies to ANY index, true?





Sure, as long as none of the indexed columns are nullable.  NULL
values aren't stored in B*-Tree indexes.



It might not work right if the index isn't UNIQUE, either, come
to think of it.  You might want to try it and see.



-bn

Received on Wed Apr 15 1998 - 11:25:16 CDT












Original text of this message













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