In case you need the number of the results, do not select data but select only count(xxx) expression. This is true for every place.