Have you vacuum analyzed recently and what does
explain show for the query?
On Thu, 10 May 2001 ryan@paymentalliance.net wrote:
> Here's the query:
>
> SELECT
> cart_row_id
> FROM
> pa_shopping_cart
> WHERE
> order_id = 20;
> [ ... ]
> There is an index on:
> just order_id
> just order_id and cart_row_id
> and a PK on cart row_id
>
> I don't understand why it's not using one of these indexes!
> Please post your responses to the group - my email is down.