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: 414 times
Last Updated: Aug 25, 2014 at 11:17 AM
DBCC Check DB issue Please Help
Help with the proper index
Import multiple excel 2010 files to SQL 2008 r2
OR operator taking time
How to subtract 2 rows based on min and max dates?
Why Stored Procedure cannot be used with Select, Where & Having. Understand function can serve the purpose. Why SP cannot
Look up and Update
SQL Query Consecutive Day Count and Sum and Group
How To Increse Hours and Get Daily Report