J,
> I have an index built for each of these columns in my order by clause.
> This query takes an unacceptable amount of time to execute. Here are the
> results of the explain:
You need a single index which has all five columns, in order.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco