How to efficiently check for existence of a row?

[Amir Michail]

Hi,

Given some condition, how do you efficiently check whether there is at
least one row that satisfies that condition?

count(*) is slow.

Amir

-- 
http://chatbotgame.com
http://numbrosia.com
http://twitter.com/amichail