In sql server, Indexing is faster in which datatype comparatively?

[Suave_Shiva]

:) Hi Frds, If we are using Indexing concept for searching criteria, which datatype will b faster, can you please tell me the order(Int,Date & String)??? Thank U............. Urs Suave Shiva :laugh:

[Giorgi Dalakishvili]

Int will be faster because it's easy to do comparison operations on it. Varchar and Date are less effective because it is not easy to perform mathematical operations on them and comparison operations take longer.

Giorgi Dalakishvili #region signature my articles #endregion

[Ashfield]

Int is the fastest, I think date would be next fastest as its stored as an int, then string, but its more important to get the index(es) right than worry about which datatypes are fastest - its only in the case of very large tables that you will notice any significant difference.

Bob Ashfield Consultants Ltd