Which of the following is not a limitation of view ?
A. ORDER BY Does Not Work
B. Index Created on View Used Often
C. Cross Database Queries Not Allowed in Indexed View
D. Adding Column is Expensive by Joining Table Outside View
Answer:A
Which of the following is not a limitation of view ?
A. ORDER BY Does Not Work B. Index Created on View Used Often C. Cross Database Queries Not Allowed in Indexed View D. Adding Column is Expensive by Joining Table Outside View
Explanation:Views created on indexed Columns is often used because of performance optimization problems.