Hi, I'doing some evaluation and comparison of Firebird, I'm running an inner join with count, group by and order by, over 3 tables of:

Customer: 10281 rows
Sales_fact_1997: 86837 rows
Product: 1560 rows

My query is:
Code:
select count(customer.customer_id) as cust_num_prod, product.product_name
from customer inner join sales_fact_1997 on customer.customer_id = sales_fact_1997.customer_id
inner join product on sales_fact_1997.product_id = product.product_id
group by product.product_name
order by cust_num_prod desc
My Firebird 1.5.0.4027 Release candidate seems faster than MySQL 4.0.10 gamma max, I will do a more accurate benchmark, but I'd like to know your experiences.