By default, indexes are stored in the ______ filegroup as the base table on which the index is created.
A. same
B. different
C. may be same or different
D. none of the mentioned
I got this question in class test.
I need to ask this question from Indexing Strategies topic in chapter Performance Tuning and Optimization of SQL Server
Right choice is A. same
The explanation: A nonpartitioned clustered index and the base table always reside in the same filegroup.