TABLE 1: Classic and Full-Text Indexes
Classic SQL Indexes Full-text Indexes
Stored in and controlled by the database. Stored in the file system, but administered via the database.
Several indexes per table. Automatically updated when data is inserted, updated, or deleted. Only one full-text index definition per table. You need to request population (either as scheduled or on demand).
Created and dropped using SQL statements. Created, managed, and dropped using stored procedures or GUIs.
You can create indexes on every type of column except text, BLOB, binary, or image. You can create indexes only on char, varchar, text, nchar, nvarchar, and ntext columns. Microsoft is considering binary data types for future SQL Server releases.