开发者

How to know what index is being used in SQL queries?

开发者 https://www.devze.com 2023-01-11 14:47 出处:网络
Having multiple indices for an SQL table, is there a way to know what index will be used automatically when using a specific query?

Having multiple indices for an SQL table, is there a way to know what index will be used automatically when using a specific query?

EDIT: I wanted the question to be general, but I most开发者_开发技巧ly use MySQL, PostgreSQL and SQLite


Use the EXPLAIN PLAN statement to see what the dbms will do with your query.

0

精彩评论

暂无评论...
验证码 换一张
取 消