Odd Full-Text Index Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Odd Full-Text Index Issue

Author

Topic

timgaunt
Posting Yak Master

115 Posts

Posted - 2006-04-06 : 05:03:30

Morning all, I'm hoping someone has an idea on this issue. I've got a table with FTI enabled and fully indexed however when searching the results are not what I would expect.

The table is only small (741 records) and the last population date was 06/04/2006 02:01:18 -that was an incremental population last night.

When using the query:


SELECT
    A.[RANK],
    A.[KEY],
    B.job_title
FROM
    FREETEXTTABLE(dbo.job, job_title, 'web developer') AS A INNER JOIN job AS B
        ON A.[KEY] = B.Job_Id
GROUP BY
    A.[RANK],
    A.[KEY],
    B.job_title
ORDER BY
    A.[RANK] DESC

Jobs with "web developer" in the title are coming out as results #7, 11, 12, 13, 14+ whereas the top results are things like "Application Developer, C# with .NET, SQL, High Wycombe, #163;28K + Pension" which has "developer" but not "web".

The difference in rank is only 1 or 2 but I would expect i.e. result #7 "Web Developer - Merseyside, North West" to be above.

Has anyone got any suggestions on why this is happening? (or how to sort it!!)

Many thanks in advance.

Tim

timgaunt
Posting Yak Master

115 Posts

Posted - 2006-04-06 : 13:23:55

I've just rebuilt the catalogue which seemed to sort it but then as soon as I ran start_incremental it "broke" again, it also "broke" when someone added a new job to the table (we've got background_updateindex enabled) could that affect it in anyway?

Tim

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources