Re: alternative to select count(*) : do i need to ?

You could mention index too

select count(column,index) from mytable where criteria

Al

legarema_at_uqtr.uquebec.ca wrote:

> Hi all,
>
> I am mostly programming in Pro*C 8.0.5.0.0 with an
> oracle 8.0.5 database (on aix 4.2.1.0). I have read
> some posts on this forum and on some web pages that
> are saying that it's bad programming to do a :
>
> select count(*) from mytable where criteria
>
> Most of the time I use count(*) to know if there is
> zero, one or more than one record matching my criteria.
>
> Is it really "bad programming" ?
> If yes, is why ?
> What are the alternatives ?
>
> Thanks a lot,
Received on Mon Dec 20 1999 - 19:19:50 CET