SQL Indexes are used to easily locate data in a database table without having to search every row. To create a duplicate copy of the database in SQL Index, more storage space is needed. An index stores all of the data in a table, which is logically ordered with columns and rows and physically maintained