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

Top comments (0)

All DEV content is created by the community!

Hey, if you're landing here for the first time, you should know that this website is a global community of folks who blog about their experiences to help folks like you out.

Sign up now if you're curious. It's free!