Interview Questions And Answers Forum

alisiddiqui

Banned

Registered: 2015-02-23

Posts: 949

Correct Statement:

Question:
Which statement is correct from partitioned view?

Option A):
We cannot create an indexed view on a partitioned view.
Option B):
We can create an indexed view on a partitioned view.
Option C):
We can create an indexed view on a partitioned view as long as the index is clustered.

Correct Answer is Option B):
We can create an indexed view on a partitioned view.