Re: Advice on optimizing select/index

On 22.05.2013 16:37, Niels Kristian Schjødt wrote:

> In reality the adverts that are selected is all 'active'. I'm hence
> wondering if it theoretically (and in reality of cause) would make my
> query faster if I did something like:  "SELECT .* FROM cars LEFT
> OUTER JOIN adverts on cars.id = adverts.car_id WHERE cars.brand =
> 'Audi' AND adverts.state = 'active'" with a partial index on "INDEX
> adverts ON (car_id) WHERE state = 'active'"?

That sounds reasonable to do.  If you have enough bandwidth on your
production database why not just try it out?  Otherwise you could do
this on a test database and see how it goes and what plan you get.  Btw.
did you look at the original plan?

Cheers

    robert