As a database administrator sometimes we definitely face query slowness issues. For this IBM provided tools to analyse the query and get few details about the plan how it is accessing the table and indices of the table. The main tools provided by IBM in DB2 are db2expln & db2exfmt. Both these tool gives the same output such as how the table and index scans are? how much time it is taking to get the results back. But the which one is better and what is difference between these two tools? why db2 provided two tools for single purpose.
Lets see how these two works.
Lets see how these two works.
DB2EXPLN:
Before using db2expln we need to check whether the tables related to this tool are exists or not. If these tables does not exist we need to create the tables as below: