what suggestion to tune this query or create index?

George Zhou 2017-03-08 18:18:31

Aaron Bertrand 2017-03-09 17:04:58
This is still an estimated plan, can you generate an actual from within Plan Explorer? An actual plan will provide much better clues about improvement opportunities. Also just as an aside you have a LEFT OUTER JOIN to res_room, but then you filter rows from that table in the where clause, converting the outer join to an inner join.