Which of the following statement modifies view index ?
A. ALTER INDEX
B. ALTER VIEW INDEX
C. ALTER INDEX_VIEW
D. None of the mentioned
Answer:A
Which of the following statement modifies view index ?
A. ALTER INDEX B. ALTER VIEW INDEX C. ALTER INDEX_VIEW D. None of the mentioned
Explanation:ALTER INDEX modifies an existing table or view index (relational or XML) by disabling, rebuilding, or reorganizing the index; or by setting options on the index.