SQL Quiz: What is index in SQL?

Task 45:

Select the correct SQL index definition from the options below:

An SQL index is a duplicate copy of a table stored in a separate location for backup purposes.

An SQL index is a built-in search function within the database software.

An SQL index is a mandatory component for every table in a database.

An index in SQL is an ordered data structure that allows the database to find the desired rows based on the values of the indexed columns without scanning the entire table. In most cases, an index speeds up data retrieval but slows down data modification by adding the cost of updating the index itself.

Mark all correct answers and click the "Check!" button

Login

Register