Re: Help optimizing query/index
Under what circumstances would pi.property_id not equal pi.property_id!?!
Also, given that you already have this...
INDEX IX_reservations_ratestat (property_id, departure, ratecode),
...my understanding is that this is redundant...
INDEX IX_reservations_ratesearch (property_id, ratecode)
...and you could try adding an index on rc.rate_code
Edited 2 time(s). Last edit at 03/08/2012 12:05PM by laptop alias.
Subject
Written By
Posted
Re: Help optimizing query/index
March 08, 2012 12:07PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.