How to obtain HIT COUNT together with query results?

I need to obtain a number of rows affected by the query and the query results in one step. Right now I am executing two queries:

• select * from mytable where ... order ...
• select count(*) from mytable where ... But the query is very complicated and time consuming, so it lasts twice slower. The other problem is how to get, for example, 50-60 results of 10000 matching the first query in a efficient way. Any ideas or suggestions?

Regards,
Bogdan Stepien
mailto:stepien_at_tpg.pl

PS. The queries are executed via JDBC, I used to scroll the result set to the end to find out how many rows returned the executed query. This turned out to be very fast on small result sets (up to few hunderds of rows), but recently the database has been enlarged to over 1GB... Received on Thu Apr 22 1999 - 05:15:39 CDT