|TABLE 1: Classic and Full-Text Indexes|
|Classic SQL 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.