What is the primary purpose of using an index in a database?
- To speed up data retrieval
- To enforce data constraints
- To store large binary data
- To define database structure
The primary purpose of using an index in a database is to speed up data retrieval. Indexes allow the database system to quickly locate and retrieve data, improving query performance.
Loading...
Related Quiz
- The method '______' is used to read data from a readable stream in Node.js.
- The Access-Control-Allow-Methods header in CORS specifies which HTTP ________ are allowed.
- What are the implications of choosing an improper data type for a field in a database schema on storage and performance?
- How can you ensure a specific listener is called only once for an event in Node.js?
- You are publishing a package to npm, and you want to make sure that all tests pass before the package is actually published. Which npm script would you use to run your tests before the package gets published?