In Interactive SQL you can determine which materialized view the optimizer used to satisfy a query.
There are no prerequisites for performing this task.
Contexte et remarques
When snapshot isolation is in use, the optimizer does not consider materialized views that were refreshed after the start of the snapshot for the current transaction.
In Interactive SQL, connect to the database.
Click Tools » Plan Viewer (or press Shift+F5).
Type the query in the SQL pane.
Select a Statistics level, a Cursor type, and an Update status.
Click Get Plan.
Look on the Details and Advanced Details panes to see which materialized views, if any, were used to satisfy the query.
Discuter à propos de cette page dans DocCommentXchange.
|Copyright © 2013, SAP AG ou société affiliée SAP - SAP Sybase SQL Anywhere 16.0|