You can compare two queries to know how each query is performing in terms of speed and cost effectiveness. DAS compares various aspects of the two queries, based on which you can identify what changed between the executions of those two queries, and you can debug performance-related issues between different runs of the same query.
To compare two queries:
- Sign in to DAS and click Queries.
Under ACTIONS, click the Compare
button to select a query.
The selected query is displayed on the comparison toolbar.
Next, select the query that you want to compare by clicking the
The selected query is displayed on the comparison tool bar next to the query that you initially selected.
The comparison report is displayed.
- To remove any query from the comparison toolbar, click x.
- To change the order of the queries that are being compared, click the Swap queries button on the comparison toolbar.