What is the purpose of an index in a relational database?
a. To identify the attributes that will be used as keys in queries. b. To optimize the retrieval of information and improve performance. c. To define the names of the relations and attributes in a database schema. d. To ensure the integrity of the data in the database.
The purpose of an index in a relational database is to optimize the retrieval of information and improve performance. Therefore, the correct answer is option b.
Essa resposta te ajudou?
0
0
Ainda com dúvidas?
Envie uma pergunta e tenha sua dúvida de estudo respondida!