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 -> select count(*) optimization

select count(*) optimization

From: jim nash <jimnash_at_sprintmail.com>
Date: 1997/03/05
Message-ID: <331D9E0D.4B3E@sprintmail.com>#1/1

Anyone know how to fool the optimizer into using a primary key access path to count all rows in a table? e.g.

    select count(*) from blah;

In my case the rows are very long, the prim key is very short, and the full table scan brings the machine to its knobby knees.

Received on Wed Mar 05 1997 - 00:00:00 CST

Original text of this message

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