Which factor does Visual Explain help identify in query performance tuning?

  • Database schema design
  • Disk storage utilization
  • Index selection
  • Network latency
Visual Explain in DB2 helps identify factors related to query performance tuning, such as index selection. By visualizing the access paths chosen by the query optimizer, it becomes easier to evaluate the effectiveness of indexes and make informed decisions to improve query performance. 
Add your answer
Loading...

Leave a comment

Your email address will not be published. Required fields are marked *