Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Querying the word "automatic"

 
   Database Help (Home) -> Full Text RSS
Next:  oracle RowType Issue  
Author Message
Adam Winter

External


Since: Jan 20, 2010
Posts: 1



(Msg. 1) Posted: Wed Jan 20, 2010 10:59 am
Post subject: Querying the word "automatic"
Archived from groups: microsoft>public>sqlserver>fulltext (more info?)

I have a table with approximately 80,000 records. I've created a full text
index on the table with the following statement:

CREATE FULLTEXT INDEX ON AdsAuto
(
StockNumber,
YearText,
Make,
Model,
Trim,
Transmission,
ExteriorColor,
Description,
Equipment,
FullTextKeywords,
VIN,
AdCode
)
KEY INDEX PK_AdsAuto ON TraderCatalog
WITH CHANGE_TRACKING AUTO

This query takes 13 seconds to run:
SELECT ID, Year, Make, Model, Description
FROM AdsAuto
WHERE CONTAINS(AdsAuto.*, '"automatic*"')


This query takes 2 seconds to run:
SELECT ID, Year, Make, Model, Description
FROM AdsAuto
WHERE CONTAINS(AdsAuto.*, '"auto*"')

Why does searching for the word "automatic" take so long to run? Any other
word takes only 2 seconds for the search and using a partial match like
"auto*" is fast. I've also tried searching the fields individually by using
this query:

SELECT ID, Year, Make, Model, Description
FROM AdsAuto
WHERE CONTAINS(AdsAuto.Transmission, '"automatic*"')

This is also very fast. Searching any of the individual fields for the word
"automatic" is just as fast, but when searching AdsAuto.*, it dogs the server.
Execution plans are the same when searching for "automatic*" vs. "auto*". I
cannot find the cause of the slow search.

 >> Stay informed about: Querying the word ""automatic"" 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
SQL 2K : custom word breaker ? - Hi, Is it possible to create a custom word breaker for SQLServer fulltext.... I use french word breaker, but for some specific tables, it's not exactly what I want... Seems such a dream will be feasible in SQL 2K5. Please anyone who knows, tell me the....

Returning word forms? - Microsoft SQL Server 2000 - 8.00.818 (Intel X86) <font color=purple> ; May 31 2003 16:08:15 </font> <font color=purple> ; Copyright (c) 1988-2003 Microsoft Corporation</font> <font color=purple> ; S...

hyphen as word-breaker - Hello All, I have a sql server 2005 db which contains a full text catalog on a table, certain columns on that table have a words with hyphens in them, the customer expects the results to come up when the search term contains hyphens, but looks lik...

Why do I meet "Word breaking timed" out error - Dear All, I have just migrated from SQL Server 2005 to SQL Server 2008 Beta I have a single table q_docversion with 1000 records ( f_Doc_ID int PK f_HeadLine nvarchar(510) [fulltext index column] ) when I execute following statement declare..

Q: Trying to make Word (.doc) archive SQL 2005 webapplicat.. - Hi all, I am about to start writing an application to archive MS word files to SQL 2005 DB. I have read few things about full text search. I only need text search on these word files. Any good websites with info on how to configure SQL 2005 and sample..
   Database Help (Home) -> Full Text All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]