http://blogs.msdn.com/b/sqlfts/archive/2011/10/31/looping-over-document-similarity-details-in-semantic-search.aspxStatistical Semantic Search , which is new in SQL Server 2012 “Denali,” indexes documents and text columns to support queries that go beyond the simple keyword search of LIKE or of Full-Text Search. Semantic Search lets you query for 3 types of informationen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlfts/archive/2011/10/31/looping-over-document-similarity-details-in-semantic-search.aspx#10280672Fri, 09 Mar 2012 23:02:21 GMT91d46819-8472-40ad-a661-2c78acb4018c:10280672SEMANTICKEYPHRASETABLE is super slow to me<p>I have a table (NOT a FileTable) containing 2.5M records with a field containing content of plain text. I created a Fulltext index on it with semantic option. The fulltext catalog is on a separate filegroup and file. It is now 4GB big. The index is auto track changes and populating. Then I did the following search </p> <p>SELECT TOP(10) *</p> <p>FROM SEMANTICKEYPHRASETABLE</p> <p> &nbsp; &nbsp;(</p> <p> &nbsp; &nbsp;SearchContent,</p> <p> &nbsp; &nbsp;*,</p> <p> &nbsp; &nbsp;@ID</p> <p> &nbsp; &nbsp;) AS KEYP_TBL</p> <p>ORDER BY KEYP_TBL.score DESC</p> <p>it took forever, any idea?</p> <p>Please kindly reply me gzhang@primeobjects.com.</p> <p>Cheers</p> <p>Gary</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10280672" width="1" height="1">