Copy-ready commandSQL SELECT — Basic Usage Help and Syntax
EXPLAIN SELECT * FROM users LIMIT 100;Production warning
Help and syntax commands are generally read-only. The original command shown for context may change systems or data; review it before execution.
Requirements and permissions
- Requirements
- Appropriate database client and connection
- Permissions
- No elevated permissions are normally required to view help; local policy and shell access still apply.
- Last reviewed
- 2026-07-31
Examples
Display the full reference
Requests an execution plan so indexes, scans, joins, and estimated work can be reviewed before tuning.
EXPLAIN SELECT * FROM users LIMIT 100;Original command context
The original SQL SELECT — Basic Usage example is included for context. Review all parameters before using it in production.
SELECT * FROM users LIMIT 100;Common errors
EXPLAIN syntax differs for this database engine
Use EXPLAIN ANALYZE only in a safe test environment, or consult the engine-specific execution-plan syntax.