Query optimization: Indexes make search queries much faster.
Uniqueness: Indexes like primary key index and unique index help to avoid duplicate row data.
Text searching: Full-text indexes in SQL Server, users have the opportunity to optimize searching against even large
amounts of text located in any field indexed as such.
Sort Operations: Can be used to avoid a sort operation by providing the data pre-sorted
Comments
Leave a Comment