In fact, if you use Sybase, that is the only of counting the number of rows. In essence, the only way the Sybase engine can tell you how many rows would be returned by a select is to go and fetch them.