Performance: What is the best way to check if a record exist on a table ?

Hello,

normaly you can use:

select single * from tab where x = y.

But, concerning the performance, I think there's some other better commands ...

any idea ?

tks.