Hi all. COUNT() is constant performance if you count all the rows in a table, but linear performance if you have a condition on which rows should be counted.
Is there any way to optimise the latter case? I know that indexing on the columns used in the query doesn't work. Daniel
