If you only want a hint, in postgres you could always do an EXPLAIN and see the estimated number of rows returned