Asked by Ruixuan Zhang on Sep 29, 2024
If you set the _____ property for a field that is often used for sorting,you improve database performance.
A) Sort
B) Indexed
C) Duplicates
D) Validation
Indexed
A method of storing data in a database in such a way that it improves the speed of data retrieval operations on a database table.
Database Performance
The measure of how efficiently and effectively a database system processes queries, updates, and other operations.
- Understand the mechanism of indexing and how it influences database efficiency.
Learning Objectives
- Understand the mechanism of indexing and how it influences database efficiency.