homes_info
有4列
home_id (primary_key)
title (varchar)
price (double)
location_id (foreign key)
我还有一张桌子
locations
有3列
location_id (primary key)
location_name (varchar)
location_state (varchar)
SELECT * FROM homes_info WHERE title = 'xxxxx' && price = 'xxxx'
SELECT * FROM homes_info LEFT JOIN locations on homes_info.location_id = locations.location_id WHERE title = 'xxx' && price = 'xxxxx' && location_name = 'xxxx'
ALTER TABLE homes_info ADD INDEX(title, price)
ALTER TABLE locations ADD INDEX(location_name)
我知道第一个查询是复合索引
INDEX(title, price)
LEFT JOIN
)? 使用单独的索引
title
和
price
简单地说,
谢谢!