Automatic Yes Yes Yes Yes indexed view Distributed Yes Partial. Partial. Partial. Partial. Partial. Partial. partitioned views Partition Views Views Views Views Views Views are not are not are not are not are not are not updatable Parallel Yes indexed operations Automatic Yes use of indexed view by query optimizer Parallel Yes consistency check SQL Yes Server Utility control point Contained Yes Yes Yes Yes Yes Yes Yes Databases
Automatic indexed view Yes Yes Yes Yes Distributed partitioned views Yes Partial. Views are not updatable Partial. Views are not Partial. Views are not Partial. Views are not Partial. Views are not Partial. Views are not Parallel indexed operations Yes Automatic use of indexed view by query optimizer Yes Parallel consistency check Yes SQL Server Utility control point Yes Contained Databases Yes Yes Yes Yes Yes Yes Yes Partition
VERSIONS%20n%20EDITIONS%20Compare.docx