Create and Modify SQL Server Indexes Properly November 15, 2002 Indexes are critical to smooth data retrieval and manipulation in SQL Server. They are the way foreign keys maintain relationships among themselves and the way DB pros enforce order on