Post reply

Is there any problem if I create index on string datatype

  • 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.?

  • 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

  • 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]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply