2012年3月21日星期三

Full text search

Hi
I am testing the usage of FULL TEXT feature and somehow it is not working
for me.
I have 2 rows in a table zz with values
this is a sta test
test
Now when I run the following query I do not get any rows back
but the full text index is used.
select zz from zz where contains ( *,'sta')
|--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz].&#
91;KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
Hash Match Left Semi Join
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.0
0.0 2.4346894E-2 36 0.42534244
[zz].[zz] NULL PLAN_ROW 0
1.0
|--Clustered Index Scan(OBJECT[base].[dbo].[zz].[PK_zz]))
40 4 3
Clustered Index Scan Clustered Index Scan
OBJECT[base].[dbo].[zz].[PK_zz])
[zz].[zz] 2.0 3.7578501E-2
8.0700003E-5 76 3.7659202E-2 [zz].[
zz]
NULL PLAN_ROW 0 1.0
|--Remote Scan(OBJECTCONTAINS))Can you post the results of the following queries?
select FulltextCatalogProperty('CatalogName', 'ItemCount')
replacing CatalogName with the name of your catalog. If the value is 1 or
the number of tables you are full text indexing you will have to run a
population. If you have already run a population, check the application log
using event viewer to see if there are error messages from MSSCI or
MSSearch.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> Hi
> I am testing the usage of FULL TEXT feature and somehow it is not working
> for me.
> I have 2 rows in a table zz with values
> this is a sta test
> test
> Now when I run the following query I do not get any rows back
> but the full text index is used.
> select zz from zz where contains ( *,'sta')
> |--Hash Match(Left Semi Join, HASH[zz].[zz])=([FULLTEXT:zz
].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY])) 40 3
1
> Hash Match Left Semi Join
> HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),
> RESIDUAL[zz].[zz]=[FULLTEXT:zz].[KEY]) NULL 1.
0
> 0.0 2.4346894E-2 36
0.42534244
> [zz].[zz] NULL PLAN_ROW
0
> 1.0
> |--Clustered Index Scan(OBJECT[base].[dbo].[zz].[
PK_zz]))
> 40 4 3
> Clustered Index Scan Clustered Index Scan
> OBJECT[base].[dbo].[zz].[PK_zz])
> [zz].[zz] 2.0 3.7578501E-2
> 8.0700003E-5 76 3.7659202E-2 [zz].
1;zz]
> NULL PLAN_ROW 0 1.0
> |--Remote Scan(OBJECTCONTAINS))|||Thanks. I did check in event viewer and came across this warning when I trie
d
to do the full load
The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
also
select FulltextCatalogProperty('zz', 'ItemCount')
0
mangesh
"Hilary Cotter" wrote:

> Can you post the results of the following queries?
> select FulltextCatalogProperty('CatalogName', 'ItemCount')
> replacing CatalogName with the name of your catalog. If the value is 1 or
> the number of tables you are full text indexing you will have to run a
> population. If you have already run a population, check the application lo
g
> using event viewer to see if there are error messages from MSSCI or
> MSSearch.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
> message news:3E800AE8-603F-4ADF-BCE8-1C3B27174547@.microsoft.com...
> 0.42534244
>
>|||The below kb addresses the most frequent cause of this problem.
http://support.microsoft.com/defaul...kb;en-us;317746
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Mangesh Deshpande" <MangeshDeshpande@.discussions.microsoft.com> wrote in
message news:530DC499-0431-4030-A02A-5658AC5E3EE5@.microsoft.com...
> Thanks. I did check in event viewer and came across this warning when I
tried[vbcol=seagreen]
> to do the full load
> The crawl seed <MSSQL75://SQLServer/182c9b23> in project <SQLServer
> SQL0000500005> cannot be accessed. Error: 80040e09 - Permission denied. .
> also
> select FulltextCatalogProperty('zz', 'ItemCount')
> 0
> mangesh
> "Hilary Cotter" wrote:
>
or[vbcol=seagreen]
log[vbcol=seagreen]
in[vbcol=seagreen]
working[vbcol=seagreen]
HASH[zz].[zz])=([FULLTEXT:zz].[KEY]),[vbcol=seagreen]
0[vbcol=seagreen]
[zz].[zz][vbcol=seagreen]

没有评论:

发表评论