The values of the elapsed time between an Original SQL and Best Alternative in the Report Comparison tool have incorrect values.
The issue is consistent across optimizations of dramatically different queries. An example is in the Total Elapsed Time and Execution CPU Time; the Time Saved(%) is equal to 1.0 minus the percentage shown in the chart attached. But for Execution Elapsed Time, the Time Saved(%) has no obvious relationship to the actual data, and neither does the Times of Improvement.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center