David, > The problem: Doing a query for a date range on a particular store or > market, though, for a date range of more than a few days does a > sequential scan of sales_tickets, and performs worse than doing one > single date query for each date. My 'explain' for one such query is > below.
Can you run EXPLAIN ANALYZE instead of just EXPLAIN? That will show you the discrepancy between estimated and actual costs, and probably show you what needs fixing. -- --Josh Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]