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.