question

jasmy avatar image
jasmy asked

Full text Index in MS-SQL

WHat is clustered index seek for fulltext_index_docidstatus_ My execution plan shows cost on the above index. Can someone help me ?
sql-server-2008sql-server-2005sqlindexingclustered-index
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
That means it is using the clustered index on the table to find rows. Here is the description of it in the [Books Online][1]. It's likely looking up additional columns from the table after using the full text index. [1]: http://technet.microsoft.com/en-US/library/ms190400(v=SQL.105).aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.