Subject Check for existence of at least 1 record in result set
Author Stefan Heymann
What is the best and least costly way to check for the existence of at
least one record in the result set of a SELECT?

I just want to know if or if not a query will return anything. I don't
care about the contents. My query involves a NATURAL scan and I want
to stop the search engine as early as possible.

Is a SELECT FIRST 1 the solution? Or is there something else which is