A 3.3.3 Indexing activity
Topic Alignment: A3.3.3 Explain how SQL can be used to update data in a database. Evaluate the performance implications of updating data in indexed columns, and how indexes might need to be rebuilt or reorganised. In database management, an index is a supplementary data structure (often a B-Tree) that significantly speeds up data retrieval operations (like SELECT queries). It works exactly like the index at the back...