You have a table named Person that contains a nvarchar column named Surname. The Person table currently has a clustered index on PersonID. The Surname column contains Russian and Japanese characters.
The following code segment will be used to search by Surname.
IF @lang =’Russian’
SELECT PersonID, Surname
FROM Person WHERE Surname = @SearchName COLLATE Cyrillic_General_CI_AS
if @lang = ‘Japanese’
SELECT PersonID, Surname FROM Person WHERE Surname = @SearchName COLLATE Japanese_CI_AS_KS
You need to enable SQL Server to perform an index seek for these queries. What should you do?
A.
Create an index on the Surname column.
B.
Create a computed column for each collation that needs to be searched. Create an index on the Surname column.
C.
Create a computed column for each collation that needs to be searched. Create an index on each computed column.
D.
Create a new column for each collation that needs to be searched and copy the data from the Surname column. Create an index on each new column.