??? SQL Server ?????-??? ?????? ?? ??????????? ??? ?????

???? ?????? ???? ??????
???? ID: 2549443 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ???? ????? ???? ?? ?? ?????-??? ??? predicates (???? ???? ?? ?? CONTAINSTABLE) ?? ????? ???? ?? ?? ?? ???? ??????? ???? Microsoft SQL Server ?????? ?? ??????????? ?? ??????? ?? ??? ?? ????? ?????? ?? ???, ?? ???? ????? ?????? ?? ??????????? ?? ??????? ??:
select * from dbo.ftTest where CONTAINS(TextData, '"keyword"') and CDate > @date
?? ???? ???? ???? ?????? ???????, ?????? ?????? ?? ?????-??? ??????????? ?????? ???? ?? ??? ???? ???? ???, ???? ?????-??? ??? ???? ???????? ?? ??????? ?? ??? ???? ??? ??? ?????, ??????? ???? ?? ???? ??????? ??????? ???? ?? ??? ???? ???

???? ???????

?? ?? ???????? ???? ?????? ?? ??????????? ??? ?? ???? ?????-??? ??? ???? ????????? ?????? ???? ?? ?????? ?? ?? ?????-??? ??? ??????, ???????? ??????? ????? ??? ????? ?? ??????? ???? ???? ???? ??? ??? SQL ?????, ??? ?? ????????? ?? ??? ??? ??????? ???? ???? ????? ?? ?????? ?? ???? ?? ??? ????????? ?? early ?????????? ?????? ?? ??????????? ????? ???? ????

??? SQL ????? ?? ??????? ?? SQL Server 2008 ???? ?? ???? ?????? ???? ??? ??, ?????-??? ??? ???? ?? ??? ?????? ?? ??? ???? ??? ????????? ???? ??, ?? ??? ??????? ???? ???? ?? ??????? ???? ???? ??? SQL Server 2008 ???, SQL Server 2008 R2 ?? SQL Server 2012 ??? ?? ??????? ???? ?? ??? ????? ??? ?? ???? ???????, ?????-??? ??? ??????????? ??????? ??????????? ?? ???? ????? ????? ?? ????????? ???, ??????? ?? ??????? ?? ????? ???? ?? ??? ???? ???? ??? ??? ??, ?????-??? ??? ???? ?? ??????? ???? ???? ????? ????? ?? ??? ????? ?????, ?? ???? ??? ?????? ???? Table-Valued ??????? (TVF) early ????????? ?? ??????? ???? ?? ??? ?? ??? ??? ??????? ???? ????? ????????? ?? ?????? ?? ?? ???? ?? ??? ???? ???

?????? ?? ???, ????? ?????? ????? 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 
?????? ?????-??? ??????????? ???????? ????? ????? ?? predicate ?? ??? ??? ????? ???, ?? ???????, ?????-??? ??? ???? predicate ?????-??? ???? ?? ???????? ?? ??????? ???? ?? ??? ????? ?? ???? ???? ???????? ?????????? ???? ???? ???? ????? ???? ???? ?? ?? ?????? ???, 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
?????-??? ??? ???? ?? ?????? ?? ????? ??????????? ????? ?? ????? ???? ???? ?? ????? ?? ??? ???? ?? ??? ????? ???? ?? ??? ???? ???

?? predicate DateTime ???? ?????? ????? ???, ?? ???? ?? predicate ?? ??? ???? ????????? emitted ??? ???? ?? ?????? ??????? ????? ??????????? ????? ????? ??? ????? ?? ???? ???? ??? ???? ?? ??? ?? ??????? ????? ????? ????? ??? ?????? ??????? ????? ???? ?????? ???????, ?? ?? ????? ????? ???? ?????? ?? ?????? ?? ????? ???? ???? ????????? ?? ????????? ???? ?? ??? ??? ???? ???

?????? ?? ??????????? ???? ?? ???, ?????-??? ?? ????? ???? ?????? ????? ID BIGINT ????? ??? ???? 4 ?????? ?? ????? ID ?????? ????, ???, ?? ?????? ????? ?? ?????? ?????, ?? ????? 4 ?????? ?? ?? ?? ???? ???? ?????? ?? ???, ???? ???? ????? ID ?? ??? ???? ?? ?????? ???? ?? ????? ??? ???? ???? ???????? ???, ?? ????? ?? ?????? ???? ???? ?? ??? ????? ?? ???? ????????? ?? ???? ?????? ???????? ?? ???????? ???? ?????

???? ???, ????? ?? ?? predicate ?? ??? ?? ?????? predicate ?? ?????? ???? id. ?????? ?? ???, "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="">

???

???? ID: 2549443 - ????? ???????: 22 ????? 2013 - ??????: 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 KbMthi
???? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:2549443

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com