Re: Help optimizing query/index

[Chris T]

Sorry, I did paste that into my original post w/ code tags, but for some reason it runs off the side of the page. IDK why it doesnt do a newline.

+----+-------------+-------+--------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+---------+---------------------------+--------+----------+----------------------------------------------+
| id | select_type | table | type   | possible_keys                                                                                                                        | key                         | key_len | ref                       | rows   | filtered | Extra                                        |
+----+-------------+-------+--------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+---------+---------------------------+--------+----------+----------------------------------------------+
|  1 | SIMPLE      | rs    | range  | IX_reservations_extract_dup,IX_reservations_search_date,IX_reservations_roomstat,IX_reservations_ratestat,IX_reservations_ratesearch | IX_reservations_search_date | 4       | NULL                      | 579472 |   100.00 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | rc    | ALL    | NULL                                                                                                                                 | NULL                        | NULL    | NULL                      |     44 |   100.00 |                                              |
|  1 | SIMPLE      | pi    | eq_ref | PRIMARY                                                                                                                              | PRIMARY                     | 3       | rribi_test.rs.property_id |      1 |   100.00 | Using where; Using index                     |
+----+-------------+-------+--------+--------------------------------------------------------------------------------------------------------------------------------------+-----------------------------+---------+---------------------------+--------+----------+----------------------------------------------+