SQL语句编写顺序
SELECT
DISTINCT
FROM
ON
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
SQL语句执行顺序
FROM
ON
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
ORDER BY
LIMIT
复合索引的执行顺序尽量和sql语句执行顺序相同,避免跨列,乱序使用,导致索引失效。
SQL语句编写顺序
SELECT
DISTINCT
FROM
ON
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
SQL语句执行顺序
FROM
ON
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
ORDER BY
LIMIT
复合索引的执行顺序尽量和sql语句执行顺序相同,避免跨列,乱序使用,导致索引失效。