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

Would Oracle use index on count(*)?

From: aa <aau_at_interlog.com>
Date: Mon, 13 Apr 1998 23:20:08 -0400
Message-ID: <6gukqg$24s$1@news.interlog.com> 





When I issue an Select count(*) from Table, Oracle always performs a table
scan even though an index is available. In MS SQL Server, the optimizer will
chose to scan the index (if one is available) instead of the table. Why
doesn't Oracle do this?


Received on Mon Apr 13 1998 - 22:20:08 CDT












Original text of this message













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