April 17, 2009 at 12:30 am
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
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
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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy