以下幾條陳述句查詢時經常用到，要怎么加索引或者給哪些欄位加索引會加快查找。謝謝。。。
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND (
STATUS = 'SCHEDULED'
OR STATUS = 'AWAITING'
)
AND END_DATE > NOW()
SELECT
FROM Cmdt
WHERE IS_PATIENT = 0
AND STATUS = 'SCHEDULED'
AND END_DATE > NOW()
SELECT
FROM C_mdt
WHERE STATUS = 'SCHEDULED'
AND RESERVATION_ID = '66'
uj5u.com熱心網友回復：
只從查詢上看的話，兩個復合索引IS_PATIENT ,status, END_DATE
STATUS ,RESERVATION_ID
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/118056.html
標籤：MySQL
上一篇：mysql三表關聯，根據主表回傳的值，確定選擇那個表查詢
下一篇：MYSQL 如何修改時區