Testing method and testing device for database modification effects
The invention provides a testing method and a testing device for database modification effects. The testing method includes the steps: determining to-be-detected database access statements including to-be-optimized database access statements related to modification of a database; before the database...
Gespeichert in:
| Hauptverfasser: | , , |
|---|---|
| Format: | Patent |
| Sprache: | chi ; eng |
| Schlagworte: | |
| Online-Zugang: | Volltext bestellen |
| Tags: |
Tag hinzufügen
Keine Tags, Fügen Sie den ersten Tag hinzu!
|
| Zusammenfassung: | The invention provides a testing method and a testing device for database modification effects. The testing method includes the steps: determining to-be-detected database access statements including to-be-optimized database access statements related to modification of a database; before the database is modified, generating a first execution plan for the to-be-detected database access statements; after the database is modified, generating a second execution plan for the to-be-detected database access statements; and evaluating the modification effects of the database according to the first execution plan and the second execution plan. The testing method and the testing device have the advantage that the database modification effects can be tested simply, quickly, accurately and economically. |
|---|