Post reply

Full text index

  • May 10, 2005 at 10:04 am

    #152403

    If you have a field included in a full text index, is it of any benifit to also have it as a regular index...ei are there times when SQL might not use a full text index but would use the standard index ?

    Thanks

    rw

  • May 10, 2005 at 10:14 am

    #557828

    Actually it's the other way around.. sql won't use full tect search unless you specifically ask it to.

  • May 10, 2005 at 10:53 am

    #557839

    What do you mean "ask it to"? If I have criteria based on a field in the full text index, SQl will not use the full text index by default?

  • May 10, 2005 at 11:22 am

    #557850

    Create an full text index and index a column with it then run this :

    Select * from dbo.YourTable where IndexedCol = 'blabla'

    Select * from dbo.YourTable where CONTAINS (IndexedCol, 'blabla')

    and lookup the execution plans.

  • May 10, 2005 at 12:40 pm

    #557864

    Thanks, that answers the question!

    rw

Viewing 5 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply