What is db2expln in DB2 ?
It is used for DB2 query tuning
& once you've identified a slow running query causing a bottleneck - use
this process to analyse the access path.
Syntax ::
db2expln -d dbname -g -f
<filename> -t
It is used for DB2 query tuning
& once you've identified a slow running query causing a bottleneck - use
this process to analyse the access path.
Syntax ::
db2expln -d dbname -g -f
<filename> -t
Comments
Post a Comment