You work as a database administrator at ABC.com.ABC.com is making use of a SQL Server 2008
R2 instance to manage and maintain its databases.
The SQL Server 2008 instance includes a database that has a table, named ABC_Tbl. You then
configure ABC_Tbl to include a Geography data type column, named ABC_Colmn.
You have been instructed to devise a solution that makes allowance for ABC_Colmn to include a
spatial index.
Which of the following actions should you take?
A.
You should consider configuring ABC_Colmn with a primary key.
B.
You should consider configuring ABC_Tbl with a primary key.
C.
You should consider configuring ABC_Tbl with a clustered index.
D.
You should consider configuring ABC_Colmn with a clustered index.
Explanation: