January 21, 2008 at 7:54 am
I just want to get a bit of insight on this issue...When you get text fields like
where [Name]='Dialler Wrap Code'
or
where text = 'Called Client and the client will only be able to pay in a months time. This is the second time the client has broken their promise'
What type of indexing strategy should be used in a case like this and why ?
January 21, 2008 at 8:50 am
have you tried full text indexes?
January 21, 2008 at 12:23 pm
Unless these are full strings you are searching for then indexing won't get you seeks (although it may allow index scans which would probably still be faster than table scans) if you use LIKE or charindex or something similar. If you need to get hits on word or words then full text probably is the way to go.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
January 22, 2008 at 12:21 am
I will try the full text indexing strategy and see what sort of performance I get if not I will go for the hits on words
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply