WHat is clustered index seek for fulltext_index_docidstatus_
My execution plan shows cost on the above index. Can someone help me ?
Aug 22, 2014 at 05:56 AM
That means it is using the clustered index on the table to find rows. Here is the description of it in the Books Online. It's likely looking up additional columns from the table after using the full text index.
Aug 25, 2014 at 11:17 AM
Grant Fritchey ♦♦
Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.
Once you sign in you will be able to subscribe for any updates here
Answers and Comments
Need long-form SQL discussion? SQLserverCentral.com is the place.
asked: Aug 22, 2014 at 05:56 AM
Seen: 420 times
Last Updated: Aug 25, 2014 at 11:17 AM
Help with the proper index
csv data to separate columns
Dynamic sql query to convert single column string delimited with semicolon (;) to multiple columns
Finding duplicates in a table
Queries returning different results
we only want to see id, who, either before, or CURRENT in the year 2005,
DBCC Check DB issue Please Help