Re: Record row count and execution time into table?

Mark D Powell wrote:
> 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 --

and is more complete than my version, though fast index scans weren't available then IIRC. Thanks Mark.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com