Re: select count(*) optimization

Tell it explicitly to use the index, using a hint:

SELECT /*+ INDEX_ASC(blah PK_BLAH) */

   COUNT(*)
   FROM blah;

> > >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.
 

-- 
Joe Rogers
Intelligent Information Systems, Inc.
joer_at_renewal-iis.com