Comparison of Full-text indexes and normal indexes

Normal SQL Index Full-text indexing Storage is controlled by the database in which they are defined. stored in the file system, but managed through the database. Each table allows several common indexes. Only one Full-text index is allowed per table. They are automatically updated when the data on which they are based is inserted, updated, or deleted. Adding data to a Full-text index is called a fill, and full-text indexing can be requested either through a schedule or a specific request, or it can occur automatically when new data is added. Do not group. Group into one or more full-text catalogs within the same database. Create and drop using SQL Server Enterprise Manager, wizards, or Transact-SQL statements. Create, manage, and drop using SQL Server Enterprise Manager, wizards, or stored procedures. Unlike the normal index update immediately, full-text indexing is generally maintained on a regular basis, so for frequently updated data is not appropriate, the need to do full-text indexing of the object is generally a paper page and so on, but also suitable. Others feel that with the%like% in the amount of data can be small, of course, there must be a trade-off.