Is there any problem if I create index on string datatype

• ManoharV

  SSCommitted

  Points: 1730

  More actions

  April 17, 2009 at 12:30 am

  #130131

  As per the functionality we have to search on a particular field which is string datatype...

  As that field holds description of particular product, we have to fetch results based on that description.

  Willl it be a problem if I add index on string datatype.

  Will it matter as records in that table grows.?

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  April 17, 2009 at 6:26 am

  #979576

  Hi

  It depends... If you have queries like "Description='MyDescription'" your index will work fine. If you usually have queries like "Description LIKE '%PartOfDesc%'" you should consider to use a full-text index.

  Greets

  Flo

• Atif-ullah Sheikh

  SSChampion

  Points: 12495

  More actions

  April 21, 2009 at 1:16 am

  #981223

  There is also a limitation on Index Size. AN index will not be created on the column greater than 900 bytes. Full text Search will be better option.

  ----------------------------------------------------------------------------------------------------------------------------------------------------------------------

  Sometimes, winning is not an issue but trying.

  You can check my BLOG [font="Arial Black"]here[/font][/url][/right]