Re: select count(*) optimization

G'day Jim

Try

select count(primary_key_column_name) from blah;

Bob Johnson

jim nash <jimnash_at_sprintmail.com> wrote in article <331D9E0D.4B3E_at_sprintmail.com>...
> 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.
>
> - Jim
>
>
Received on Fri Mar 07 1997 - 00:00:00 CST