What is the benefit of creating an index on a table?

What is the benefit of creating an index on a table?

What is the benefit of creating an index on a table?

A.
To quickly retrieve records from a table without scanning the entire table.

B.
To constrain a column to a specific set of values.

C.
To guarantee uniqueness for a column.

D.
It can be used to establish a relationship to another table via a FOREIGN KEY.



Leave a Reply 0

Your email address will not be published. Required fields are marked *