A blog about IBM i (AS/400), MQ and other things developers or Admins need to know.
星期三, 12月 15, 2010
星期日, 12月 12, 2010
星期五, 12月 10, 2010
星期四, 12月 09, 2010
星期五, 12月 03, 2010
星期四, 12月 02, 2010
How to find out indexes created or used during the execution of an SQL statement
Two methods as following:
1. Visual Explain tool, through iSeries Navigator.
2. - chgjob (4 0) *seclvl logclpgm(*yes)
- strdbg
- run your sql statement from interactive sql400
- quit sql400
- enddbg
and watch the joblog to see which indexes where used/built.
星期三, 12月 01, 2010
訂閱:
文章 (Atom)