In Sybase, one can view the IO statistics of a query using the follow:
set noexec on
set statistics io on
The allows one to see the total logical IO for a query without actually executing it. Is there an equivalent sort of command for db2?
A:
The EXPLAIN statement may provide some of what you want (I'm afraid I don't have actual use details), or Visual Explain if you have access to that.
Bitwise
2010-06-16 15:53:03
Visual Explain because I can't add two links in the same post:http://www.devx.com/getHelpOn/10MinuteSolution/16567/1954
Bitwise
2010-06-16 15:53:28