Question

Point out the correct statement.

(a) On x86-based systems, creating a table or index with more than 1000 partitions is possible

(b) Compressing large tables or indexes can have manageability and performance benefit

(c) Partitioning slow tables or indexes can have the following manageability and performance benefit

(d) None of the mentioned

I got this question during an interview.

I'd like to ask this question from Partitioning in chapter Performance Tuning and Optimization of SQL Server

Answer 1

Correct choice is (a) On x86-based systems, creating a table or index with more than 1000 partitions is possible

The explanation is: Partitioning feature is not supported on x86 system.