During performance testing, you notice that a specific query is causing high disk I/O. Which profiling tool feature should you use?
- Database Tracing
- Index Advisor
- Query Execution Plan
- Query Profiler
Using a query profiler can help analyze the execution path of the query and identify areas for optimization to reduce disk I/O.
Loading...
Related Quiz
- Data consistency testing often involves comparing data in which two primary locations of a database?
- A _______ is a pre-defined set of test data and expected results used during script execution.
- Which factor should be your top priority when choosing a test data generation tool for a healthcare database containing sensitive patient information?
- Which keyword is used to specify the action to be taken when an error occurs in a SQL query?
- Which key management technique is crucial for ensuring the security of encrypted data in a database?