In Sybase, one can view the I/O 开发者_如何学JAVAstatistics of a query using the following:
set noexec on
set statistics io on
This allows one to see the total logical I/O for a query without actually executing it. Is there an equivalent sort of command for DB2?
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.
Explain: http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/com.ibm.db2.udb.admin.doc/doc/r0001001.htm
精彩评论