"Hardy" <yh********@hotmail.com> wrote in message
news:ca***********@mail.cn99.com...
DB2 gurus, I'm pretty new in DB2, or database field. Now I wanna some
tools which can measure the speed SQL stmt. be excuted. Is there any one in the
DB2 software bundle?
Thanks!
Look at the db2batch program described in the Command Reference manual. This
will give information about actual time for an SQL statement to execute.
If you want a theoretical estimate of the "relative" time, you can use the
DB2 Explain function. This can be executed as a command or using the Visual
Explain Tool in the Command Center. The explain show the access path (such
as using a particular index) that the query will use, in addition to giving
a timeron estimate. A timeron is not an elapsed time estimate, but a
relative number useful when comparing different scenarios.