ben would something like this work in your situation?
SELECT customer.id, customer.name, deliveries.calendar_day,
deliveries.delivered
FROM ben_customers as customer, ben_deliveries as deliveries
WHERE customer.id = deliveries.customers_id
and deliveries.calendar_day in (Select day
from ben_calendar
where day < 20061201 and day >= 20060101)
I think that would cut down the deliveries table fairly quickly, thus
making the customer_id join nice and quick. You would also only be
returning data from the tables in your from clause. I suppose it
depends on what you are trying to display. If you want a list of all
the possible days, and deliveries on those days then I'd approach it a
bit differently.
On Dec 15, 7:59 pm, [EMAIL PROTECTED] (Benjamin Smith) wrote:
>
> What can I do to improve the performance of this oft-used query? Is there a
> better way to do this, or am I doomed to looping thru results and parsing the
> results in code?
>
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
