#991

Paid Orders by Date

Finance analytics looks only at rows in orders with status = 'paid', starting from a given created_at. Create a compact partial index on created_at only for paid orders.

Speed this query up with an index
CREATE INDEX ix_orders_paid_created ON orders (created_at) WHERE status = 'paid'

CREATE/ALTER/DROP biss — l-ebda SELECT fl-aħħar mhu meħtieġ.

Ir-riżultat tal-query tiegħek jidher hawn