What is the primary purpose of indexing in databases?
- Speed up data retrieval
- Reduce storage space
- Enhance data security
- Sort data alphabetically
The primary purpose of indexing in databases is to speed up data retrieval. Indexes provide a quick way to locate specific rows in a large database table, improving query performance. While indexing may use additional storage, its main benefit is optimizing data access.
Loading...
Related Quiz
- In JavaScript, a variable declared without the var, let, or const keyword inside a function becomes a property of the ________ object.
- What is a closure in JavaScript?
- Which method in Express is used to handle HTTP GET requests to a specified route?
- In Node.js, the process.on('exit', handler) event listener can only perform synchronous operations and cannot perform __________.
- What is the primary function of the Event Loop in Node.js?