Post reply

Create full text index

  • March 30, 2017 at 9:55 am

    #320050

    I have table with huge amount of records (about 1 bilion records)
    Is it possible to create full text index on some part of table for  example data which its ids are greater than specific id

  • March 30, 2017 at 5:06 pm

    #1935889

    farax_x - Thursday, March 30, 2017 9:55 AM

    I have table with huge amount of records (about 1 bilion records)
    Is it possible to create full text index on some part of table for  example data which its ids are greater than specific id

    One option is that you can create full text indexes on indexed views where the view limits the columns and rows. Create the view with schemabinding and add a unique clustered index.

    Sue

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

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