摘要 |
A method of collecting data relating to the manner in which a SQL statement referencing a database was executed and a computer program and computer program product implementing the method are provided. The method comprises obtaining an execution plan and associated performance factors for the SQL statement, obtaining predetermined statistical data relating to the database referenced by the SQL statement, generating at least one output file containing the SQL statement, the execution plan, the performance factors and the predetermined statistical data, and generating a SQL script which enables the predetermined statistical data to be recreated when executed on a second database, wherein the SQL script is executed on the second database to recreate the predetermined statistical data on the second database and wherein the SQL statement is analyzed by executing it on the second database after recreating the predetermined statistical data.
|