From: martinj@worldonline.nl (Martin Jesterhoudt) Subject: Re: URGENT NEED OF HELP ABOUT PL/SQL Date: 1997/09/09 Message-ID: <34145ba1.8126785@news.worldonline.nl>#1/1 References: <3403D8D5.29FF@romeo.sci.univr.it> <3403EB15.B9E6DF70@adra.se> <5ubpog$hmt@camelot.dsccc.com> <3409e32a.7148979@news.worldonline.nl> <340d769e.5416132@news.sas.ab.ca> Organization: World Online Newsgroups: comp.databases.oracle.misc On Wed, 03 Sep 1997 14:40:19 GMT, dave@fifthd.ca (Dave Macpherson) wrote: >>Use select count() 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 -------------------------------------------------------------------------------