????? ???? ????????? ???? ?????? ?? SQL Server

???? ???????: 2549443 - ??? ???????? ???? ????? ????? ??? ???????.

???? ????? ????? ??????? ?????? ?????? ???????

??? ??? ???? ?????? ???? ?? ??????? ???? ??? ????

????? ???? | ?? ????

??????

???? ??? ??????? ????? ?????? ???? ??????????? ???? ?????? ????? ??????? ??? ?? ???? (??? CONTAINSTABLE? ????? ??? ) ????? ???? ????? ???????? ?? Microsoft SQL Server. ??? ???? ??????? ???? ??? ??????? ??? ????? ???? ????????? ??????:

select * from dbo.ftTest where CONTAINS(TextData, '"keyword"') and CDate > @date

??? ??????? ???? ?? ????? ????????? ????? ???? ???? ???? ?????? ?? ??? ??? ????? ?? ???? ??? ?? ???? ????? ??????? ??? ??????? ??? ???? ?????????. ????? ??? ???? ???? ????????? ?????? ?????? ?????? ?????.

??????? ????

????? ???? ?????? ??????? ??? ?? ???? ?? ???? ???? ????????? ?? ???? ???????? ???? ??? ?????? ???? ??? ?? ???? ??? ????????? ???? ???? ??? ????? ???????? ??? ???? ?????????. ?? SQL Server? ????? ????? ???? ????????? ?? ???? ????? ?????? ????? ?????? ??? ?????? ???? ??? ?? ??? ???????? ??????.

?? ??????? SQL Server ???? ?? ??????? ?? ??? SQL Server 2008? ???? ??? ?? ???? ????? ???? ?????? ???? ????? ????? ???? ??? ?? ????? ???? ????????? ??? ????? ?????. ?? ????? ??????? ??? ??? ?????? ?? SQL Server 2008 ??? SQL Server 2008 R2 ??? ??? 2012 ???? SQL. ??? ???? ?? ????? ??????? ??? ????????? ??? ??? ????? ????? ???? ?????? ????? ???? ????? ????? ?? ????? ????? ????????. ???????? ??? ???? ???? ??? ?? ???? ????? ????????? ???? ???? ????? ?????. ????? ?????? ??????? ???? ????? ??? ??????? ?????? ??????????? (TVF) ?????? ?????? ????? ?????? ??? ?????? ???? ??? ?? ??? ???????? ??????.

??? ???? ??????? ??? ????????? ?????? ?????? ?????? ???? ????? ????? ??? ????? ??? 131051. ???????? ??? ???? ???? ???? ????? ??? ?? ????? ????? ?????? ???????? ??? ????.

Rows StmtText 
-------------------- -----------------------------------------------------------------------------------------------------------
1167 select CDate, ID from dbo.fttest where contains (c2, '"create"') and CDate> '08/05/2019' 

1167 |--Merge Join(Left Semi Join, MERGE:([FTSdb].[dbo].[fttest].[ID])=(FulltextMatch.[docid]), RESIDUA
5858 |--Sort(ORDER BY:([FTSdb].[dbo].[fttest].[ID] ASC)) 
5858 | |--Clustered Index Seek(OBJECT:([FTSdb].[dbo].[fttest].[clidx1]), SEEK:([FTSdb].[
131051 |--Table-valued function

??? ???? ??? ???? ????????? ???? ??????? ???? ???? ?????? ?????? ????? ?????? ???? ??? ?? ???? ??????? ???? ??????? ?????? ??????? ??? ????? ???? ??????. ?? ??? ??????? ????? TVF ???? ???? ???? ?? ???????? ??? ??? ????? ????? ??????. ??? ???? ??????? ????????? ?????? ???? ????? ????? ???? ??? ?? ?????? ?? ???? c2? ? TVF ?????? ??????? ???? ?????? ?? ????? ???? ???:

Rows StmtText 

-------- ---------------------------------------------------------------------------------------------------------------------------------
5 select CDate, ID from dbo.fttest where contains (c2, '"create"') and CDate > '08/05/2019' and ID in ( 654051, 644051, 649106, 465, 105)

5 |--Nested Loops(Left Semi Join, OUTER REFERENCES:([FTSdb].[dbo].[fttest].[ID])) 
5 |--Index Seek(OBJECT:([FTSdb].[dbo].[fttest].[idx1]), SEEK:([FTSdb].[dbo].[fttest].[ID]=(105) OR ...
5 |--Table-valued function

???? ???? ??? ?? ???? ???? ????? ????????? ?????? ????? ???? ???? ??? ????? ??????? ??????.

??? ???? ????? ????? ??? ???? ??? ?????? ??????? ????? ????? ????? ??????? ??????? ?? ???? ??????? ???? ???? ??? ????? ??? ?????? ???? ????? ???? ??????? ???. ?????? ????? ??? ????? ??????? ??????? ?? ???? ??????? ???????. ??? ???? ?? ???? ????? ??? ?????? ???? ??????? ?????????? ???? ?????? ?????????.

?????? ???????? ????? ??? ?????? ????? ?? ?????? ???? ??? ??? ???? ???? ?????. 4 ???? ?????? ?? ???????? ???? ????? ????? ??????? ???? ??????? ?? ???? ???????? ?????? ?????? ??????? ??????? ???? ??? ??. ??? ???? ??????? ?????? ????? ?? ????? ???? ???? ?? ???? ??? ?????? ???? ?? ???? ??? ?????? ?????? ??? ?????? ?????? ???? ??????? ???? ?? ???? ??? ???????. ??? ?? ????? ??????? ????? ??? ???????? ???.

??? ????? ???? ????? ???? ????? ????? ??? ??????? ????. ??? ???? ??????? "x<>< y"="" range="" predicate="" can="" be="" translated="" to="" the="" "(x*2^32="">< id="">< y*2^32)"="" predicate.="" because="" the="" translated="" predicate="" is="" a="" predicate="" on="" the="" full-text="" key,="" the="" predicate="" will="" be="" pushed="" down="" into="" the="" full-text="" streaming="" table-valued="" functions="" (stvf).="" this="" behavior="" effectively="" performs="" searches="" within="" the="" date="">

???????

???? ???????: 2549443 - ????? ??? ??????: 10/?????�??????/1434 - ??????: 2.0

????? ???

Microsoft SQL Server 2008 Developer
Microsoft SQL Server 2008 Enterprise
Microsoft SQL Server 2008 Enterprise Evaluation
Microsoft SQL Server 2008 R2 Datacenter
Microsoft SQL Server 2008 R2 Developer
Microsoft SQL Server 2008 R2 Enterprise
Microsoft SQL Server 2008 R2 Standard
Microsoft SQL Server 2012 Developer
Microsoft SQL Server 2012 Standard
Microsoft SQL Server 2012 Web
Microsoft SQL Server 2012 Enterprise

kbmt KB2549443 KbMtar

????? ????

???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????

???? ??? ????? ??????? ?????? ??????????2549443

(http://support.microsoft.com/kb/2549443/en-us/ )