When I am trying to execute below query in SSMS, the query is taking more time (more than 10 minutes) to execute due to lengthy column size (Column Name: Keywords, Column Size: nvarchar(4000)). Employee table is containing 6000 records.
Select EmployeeId, EmployeeName, Designation, Keywords From Employees Where StatusFlag = 'L'
I have created below non clustered covering index for the above table.
Create NonClustered Index NCI_Employees_StatusFlag On Employees(StatusFlag) Include (EmployeeId, EmployeeName, Designation, Keywords)
How to retrieve the data from the above table in a faster manner?