| Task
| Authorities and privileges
|
To filter:
- Explainable statements
- Explained statements
| You will need a minimum of SELECT privilege on the explain tables
|
| To view details of explained statements history
| You will need a minimum of SELECT privilege on the explain tables.
If explain tables do not exist, follow the instructions in Creating explain tables. You will need a minimum
of CREATETAB authority on the database.
|
| To change an explained statement
| You will need a minimum of UPDATE privilege on the explain tables.
|
| To remove an explained statement
| You will need a minimum of DELETE privilege on the explain tables.
|
| To dynamically explain SQL statements
| You will need a minimum of INSERT privilege on the explain tables.
If explain tables do not exist, they will be created.
|
| To view SQL text
| You will need a minimum of SELECT privilege on the system catalog
tables.
|
To view:
- Access plan graphs
-
 Database partitions
- Functions
- Optimized SQL text
- Operator details
- Optimization parameters
- Referenced columns
- SQL text
- Table spaces
| You will need a minimum of SELECT privilege on the explain tables.
|
To view:
- Column distribution statistics
- Function statistics
- Indexes
- Index statistics
- Referenced column statistics
- Statistics for page fetch pairs
- Table function statistics
- Table space statistics
- Table statistics
| You will need a minimum of SELECT privilege on the explain tables and the
system catalog tables.
|