Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: URGENT NEED OF HELP ABOUT PL/SQL
On 31 Aug 1997 12:57:52 GMT, jstrange_at_imtn.dsccc.com (John Strange) wrote:
>Also, use
> select count (rowid)
>it will run faster.
Use select count(<indexed_column>) if possible. This way you don't have to go through the table, but only the index. Even faster ;-))