Which statement is correct from partitioned view?

Options
- We cannot create an indexed view on a partitioned view
- We can create an indexed view on a partitioned view as long as the index is clustered
- We can create an indexed view on a partitioned view


CORRECT ANSWER : We can create an indexed view on a partitioned view

Discussion Board
Partitioned view

Partitioned views allow the data in a large table to be split into smaller member tables. The data is partitioned between the member tables based on ranges of data values in one of the columns. The data ranges for each member table are defined in a CHECK constraint specified on the partitioning column. You can create an indexed view on a partitioned view.

Prajakta Pandit 03-8-2017 02:01 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement