A method for use with an information retrieval system, in which the method is used for transforming a database statement containing a first subquery and a second subquery joined together, the first subquery including a group by operation over a child subquery, the method comprising removing the first subquery from the database statement thereby removing the join between the first subquery and the second subquery.