Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Explain plan
- Thread starter val02
- Start date
maxtardiveau
Programmer
Hi Val,
there is indeed. The best way to get started is to use the Command Center. Connect to your database, then enter a query and select Script->Create Access Plan.
If the explain tables have not been created before, you'll need DBA access to do that.
There are entire books written about this topic. See the DB2 docs, Administration Guide : Performance, chapter 7 for (much) more detail.
Let me know if you run into any problem.
-- Max
there is indeed. The best way to get started is to use the Command Center. Connect to your database, then enter a query and select Script->Create Access Plan.
If the explain tables have not been created before, you'll need DBA access to do that.
There are entire books written about this topic. See the DB2 docs, Administration Guide : Performance, chapter 7 for (much) more detail.
Let me know if you run into any problem.
-- Max
- Status
Similar threads
- Locked
- Question