Explanation:There are plenty of indexes in SQL Server such as full text,columnstore index in SQL Server 2012 6. 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
Answer:A
Explanation:There are plenty of indexes in SQL Server such as full text,columnstore index in SQL Server 2012 6. 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
Explanation:A nonpartitioned clustered index and the base table always reside in the same filegroup. 7. Specifying the order in which key values are stored in an index is useful when queries referencing the table have :