How Would You Find Out Whether A Sql Query Is Using The Indices You E

1.	How Would You Find Out Whether A Sql Query Is Using The Indices You Expect?
Answer» EXPLAIN PLAN can be REVIEWED to CHECK the execution plan of the query. This would guide if the expected INDEXES are used or not. Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.

How Would You Find Out Whether A Sql Query Is Using The Indices You Expect?

Answer»

EXPLAIN PLAN can be REVIEWED to CHECK the execution plan of the query. This would guide if the expected INDEXES are used or not.

Explain plan can be reviewed to check the execution plan of the query. This would guide if the expected indexes are used or not.