DEV Community

Eduardo Issao Ito
Eduardo Issao Ito

Posted on

Explain DB2 query

Write your SQL query to a file query.sql using the schema name in all tables.

db2expln -database DATABASE -t -g -terminator ';' -f query.sql

The db2advis can suggest some indices for the query:

db2advis -d DATABASE -i query.sql

Oldest comments (0)