Indexes in database are used to accelerate the data retrieval process. Queries like SELECT and WHERE clauses can be accelerated using indexes but they ultimately slow down UPDATE and INSERT statements. Index creation has no effect on the data present in a table. The CREATE INDEX statement is used create an index; CREATE INDEX statement … Continue reading Types of Indexes in SQL