if so .. check timing difference between

IF (EXISTS (Select * from MyTable)) THEN ...
and
IF (EXISTS (Select first 1 * from MyTable)) THEN ...

----- Original Message -----
From: "Albert L." <looks@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, May 06, 2003 12:49 AM
Subject: Re: [ib-support] How can I check if a table is empty?


> Isn't SELECT * returns everything, and when applied to large table,
> introduce much overheads ?
>
> Pls correct me if I'm wrong. I always think this is the case.
>
> Albert.
>
> Dimitry Sibiryakov wrote:
> > On 5 May 2003 at 15:00, mcrosman1957 wrote:
> >
> >
> >>I am developing a store procedure and a trigger in which I need to
> >>check if a table is empty or not.
> >
> >
> > IF (EXISTS (Select * from MyTable)) THEN ...
> >
> > SY, Dimitry Sibiryakov.
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>