x

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 ?

more ▼

asked Aug 22, 2014 at 05:56 AM in Default

avatar image

jasmy
70 2 8 11

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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.

more ▼

answered Aug 25, 2014 at 11:17 AM

avatar image

Grant Fritchey ♦♦
137k 20 43 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2170
x2024
x1126
x150
x27

asked: Aug 22, 2014 at 05:56 AM

Seen: 408 times

Last Updated: Aug 25, 2014 at 11:17 AM

Copyright 2017 Redgate Software. Privacy Policy