Computer scienceFundamentalsSQL and DatabasesDBMSMySQLOptimization

Explain plan

Explain useful information

Report a typo

What useful information does the EXPLAIN (not EXPLAIN-ANALYZE) operator provide?

Select one or more options from the list

Estimated number of I/O operations

Query optimization hints

Abstract number that can be used for plan comparison

Estimated number of rows in result

___

Create a free account to access the full topic