Explanation:Nonaligned index is an index partitioned independently from its corresponding table. 5. Point out the wrong statement :
A. Computed columns that participate in a partition function must be explicitly marked PERSISTED
B. The new, higher limit of 15,000 partitions affects memory, partitioned index operations, DBCC commands, and queries
C. Partitioning column is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query
D. All of the mentioned
Answer:A
Explanation:Nonaligned index is an index partitioned independently from its corresponding table. 5. Point out the wrong statement :
A. Computed columns that participate in a partition function must be explicitly marked PERSISTED B. The new, higher limit of 15,000 partitions affects memory, partitioned index operations, DBCC commands, and queries C. Partitioning column is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query D. All of the mentioned
Explanation:Partition elimination is the process by which the query optimizer accesses only the relevant partitions to satisfy the filter criteria of the query.