What is an index in SQL?

devquora
devquora

Posted On: Feb 22, 2018

 

In order to speed up the performance of the queries, the index is used. It instantly accelerates the retrieval of data from the table and database. An index can be efficiently created over a group or one column.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    SQL Server Interview Questions

    What are a database and a data warehouse?

    A database, in general, is a collection of information in a more organized form for better access...

    SQL Server Interview Questions

    What is normalization according to you and explain its different levels?

    In order to remove the redundant data, normalization is used. It also reduces the null values and enables the efficiency of indexing...

    SQL Server Interview Questions

    What do you understand by the denormalisation?

    Denormalization is the inverse process of normalization...