What role does indexing play in query optimization?
- Adds redundancy to the database
- Improves search performance by providing faster access to data
- Reduces data integrity
- Slows down query execution
Indexing plays a crucial role in query optimization by improving search performance. Indexes provide faster access to specific rows in a table, reducing the time it takes to retrieve data and optimizing query execution.
Loading...
Related Quiz
- Enabling _______ compression can reduce the size of files transferred over the network, improving overall performance.
- In SQL, the ALTER TABLE command is used to _______ an existing database table.
- The CSS flexbox layout model is used for _______ layout.
- TDD promotes writing _______ that fail before writing new code to pass them.
- What is the difference between == and === operators in JavaScript?