SQL 语句优化

[指尖上的程序员]

SELECT h.HotelId,h.hotelName ,h.hotelEnglishName,h.country,h.city,h.tow,h.Location,h.salableState,h.StarLevel,h.ProductLabel,h.HotelType,
ext.Address,ext.Rating,ext.Parking,ext.SwimmingPool,ext.Restaurant,ext.OtherFacility,ext.PickupService,ext.ForeignExchange,ext.NetworkService,
ext.OtherService,ext.AcceptCreditCard,ext.OtherPolicy,image.path as imgPath,MIN(p.Price) as Price FROM sz_hotel as h LEFT JOIN sz_exthotel as ext ON (ext.HotelId=h.HotelId)
LEFT JOIN sz_roomtype as r ON (r.HotelId=h.HotelId) LEFT JOIN sz_hotelpicture as image ON (image.HotelId=h.HotelId)
LEFT JOIN sz_DateRoomPriceInfo as p ON ( p.RoomId=r.RoomTypeId AND p.Price <>0 AND p.Price IS NOT NULL) group by h.HotelId

[benluobo]

用explain在select语句前面，贴出执行计划

[指尖上的程序员]

多谢高手：

[benluobo]

alter table sz_hotel add index ix_sz_hotel_HotelId(HotelId); alter table sz_roomtype add index ix_sz_roomtype_HotelId(HotelId); alter table sz_hotelpicture add index ix_sz_hotelpicture _HotelId(HotelId);

[benluobo]

alter table sz_hotel add index ix_sz_hotel_HotelId(HotelId); alter table sz_roomtype add index ix_sz_roomtype_HotelId(HotelId); alter table sz_hotelpicture add index ix_sz_hotelpicture _HotelId(HotelId);

[指尖上的程序员]

@benluobobo 多谢 快了很多很多