Re: count(*) vs. a cursor when determining the existing record on primary key

Slight off the subject..

Select count(*) on a table with 83 million rows (table size close to 20GB).

Time? 18.07 seconds.

Reason.

a) Table is partitioned. 
b) Local bitmap indexes exist.
c) CBO using the bitmap index in parallel for the select count(*). 

   (no hints used)

Not all problems are nails. And there's more than just the hammer in the Oracle toolbox. ;-)

--
Billy