Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> select count(*) optimization
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.