How To Create a Full Text Indexed View or Schema Binded View
To create a schema binded view or full text index on a view, we simply have to write a select statement as we do while creating any normal view fetching data from one or more tables. The only thing different we do here is creating a this view with schema binding.
Once we created a schema-bound view, we can add clustered or non-clustered indexes to this view.
Check below self explanatory example below that creates a full text index to get family details from Father and Son tables.
Comments
Post a Comment