In which you can find the fastest index searching

Posted by Shubham under Sql Server on 7/30/2012 | Points: 10 | Views : 774 | Status : [Member] | Replies : 4
In which you can find the fastest index searching :-
1. Char
2. Varchar
?

Thanks&Regards:-
Shubham Choudhary
Software Engineer
www.facebook.com/shubham.kunar



Responses

Posted by: CGN007 on: 7/30/2012 [Member] Silver | Points: 25

Up
0
Down

Posted by: CGN007 on: 7/30/2012 [Member] Silver | Points: 25

Up
0
Down
Also please have look at this http://www.codeproject.com/Articles/22853/SQL-Server-Performance-Tips-and-Guidelines

Shubham, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 7/31/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as answer if it helps...,That motivates...!!!

Shubham, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Muhsinathk on: 9/5/2012 [Member] Bronze | Points: 25

Up
0
Down
CHAR is faster than VARCHAR - some times up to 50% faster

Shubham, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response