开发者

How to view I/O statistics in DB2

开发者 https://www.devze.com 2023-01-03 11:58 出处:网络
In Sybase, one can view the I/O 开发者_如何学JAVAstatistics of a query using the following: set noexec on

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

0

精彩评论

暂无评论...
验证码 换一张
取 消