January 9, 2002 at 3:18 am
Hi! all
I have one doubt regarding the performance tuning related to queries.
We have a complex query that performs search on four columns based on the same keyword.
My idea is to create a computed column for the four fields and then perform the search.
The other question is ...whether it is possible and if so logical to use it as an unique field so that a full text Indexing can be performed with Microsoft Search service.
Please post your views.
Thanks in advance.
January 9, 2002 at 10:11 am
Can you post the DDL for what you are intending. Not sure if a computed column will work without seeing some sample.
Steve Jones
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 9, 2002 at 8:08 pm
Hello! Steve
the thing is , we write our queries and business logic in the DLL.actually the query is inside a loop that performs using wild card character search with LIKE operators.If the keyword has one or more than one words and space in between each word, the program adds the "%" signs to the both ends and does the search.basically it is the way in which it was designed.It is a big chunk of conditions and queries..so it is hard to send u the query.I also will give a try by adding a computed field and will get back to u later.
any idea is greatly appreciated.
Thank you Steve.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply