DEV Community

Eduardo Issao Ito
Eduardo Issao Ito

Posted on

2 3

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)

Sentry image

See why 4M developers consider Sentry, “not bad.”

Fixing code doesn’t have to be the worst part of your day. Learn how Sentry can help.

Learn more

👋 Kindness is contagious

Please leave a ❤️ or a friendly comment on this post if you found it helpful!

Okay