Shuvra
Reputation: 212
Nvarchar perform better than varchar?
I am really surprisde to see that in my MS SQL table, I am defining a field varchar and doing group by with another table's field.
When I do the same thing with the column as nvarchar it is 3 second faster than varchar
when, theoretically, varchar should be faster because of 1 byte char.
Can anyone explain me why nvarchar is faster in this instance?
Thanks in advance.
Upvotes: 3
Views: 1565
Answers (1)
Eystein Bye
Reputation: 5126
Operating systems use Unicode internally. I think that makes nvarchar faster since it does not need any converting.
Upvotes: 1
Related Questions
- What is the difference between varchar and nvarchar?
- Good practices of SQL Server: nvarchar(max) performance
- What are the main performance differences between varchar and nvarchar SQL Server data types?
- Efficiency difference between varchar(n) and varchar(m) in SQL Server -- this is NOT about varchar(n) and varchar(MAX)
- SQL VARCHAR vs NVARCHAR in CAST performance
- SQL performance: Is there any performance hit using NVarchar(MAX) instead of NVarChar(200)
- Performance implication on nvarchar(4000)?
- Is there a reason why I shouldn't use NVARCHAR in Sql Server?
- SQL nvarchar Performance
- Sql Server int vs nvarchar comparison on performance?