Re: URGENT NEED OF HELP ABOUT PL/SQL

On Wed, 03 Sep 1997 14:40:19 GMT, dave_at_fifthd.ca (Dave Macpherson) wrote:

>>Use select count(<indexed_column>) if possible. This way you don't
>>have to go through the table, but only the index. Even faster ;-))
 

>I thought Oracle was smart enough to optimize "count(*)" to use
>whatever the fastest method should be. I don't believe there is any
>performance penalty for coding it this way.

If you've not analysed your tables for some reason, this directive can be handy.

• Martin Jesterhoudt
• martinj(replace this by @)worldonline.nl

  ---