Re: Record row count and execution time into table?

If anyone is curious about how Oracle performs count the "whoops" link I responded with on my first response post actually shows the explain plans for select count(*) on tables with and without PK, on nullable and non-nullable indexed columns, and with where clauses including "is null" and "is not null" conditions.

HTH -- Mark D Powell -- Received on Mon Oct 03 2005 - 09:42:07 CDT