Index on nvarchar column doesnot affect performance (sql server)
-
Hello, I have a column in table that have nvarchar(200) datatype and then I add index on another column include my nvarchar(200) column but the performance is the same when I do a select query with where condition in the nvarchar(200) column I need to know why the index on nvarchar column doesn't affect the performance?
-
Hello, I have a column in table that have nvarchar(200) datatype and then I add index on another column include my nvarchar(200) column but the performance is the same when I do a select query with where condition in the nvarchar(200) column I need to know why the index on nvarchar column doesn't affect the performance?
Answered in QA: Index on nvarchar column doesnot affect performance[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Answered in QA: Index on nvarchar column doesnot affect performance[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
IS there any explanation for this ?
Answered in QA: Index on nvarchar column doesnot affect performance[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
