Designing an nonaligned partitioned index can be useful in the following case?
(a) The base table has not been partitioned
(b) The index key is unique and it does not contain the partitioning column of the table
(c) You want the base table to participate in collocated joins with more tables using different join columns
(d) All of the mentioned
I have been asked this question during an interview.
My doubt is from Partitioning topic in portion Performance Tuning and Optimization of SQL Server