Indexed View Queries [Microsoft SQL Server]
| Query | The Returned Rows Indicate | Resolution |
|---|---|---|
|
IVIEWS-1 |
Indexed views or summary tables which are defined in Application Designer, but are not found in the database. |
Use Application Designer to Build the indexed views or summary tables. |
|
IVIEWS-2 |
Indexed views or summary tables which are defined in the database, but are not found in the Application Designer. |
Drop the indexed view or summary table if it is not valid. Otherwise, define a new indexed view or summary table in the Application Designer. |
|
IVIEWS-3 |
Indexed views or summary tables which are missing a related language record. |
Use the Application Designer to add a related language record for the indexed views or the summary tables. |
|
IVIEWS-4 |
Indexed views whose keys are not defined. |
Use the Application Designer to set the keys for the indexed views. |