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.