In this lecture we look at...
[Section notes PDF 180Kb]
- 2.2.01. Introduction
- 2.2.01b. Machine architecture (by distance)
- 2.2.01c. Machine architecture (by capacity)
- 2.2.02. Database internals
- 2.2.03. Disk fundamentals
- 2.2.04. RAID technology
- 2.2.05. RAID levels
- 2.2.06. Records and fields
- 2.2.07. Fields
- 2.2.08. Primary organisation
- 2.2.09. Indexes/indices
- 2.2.09b. Primary index example
- 2.2.10. Primary Index file (as pairs list)
- 2.2.10b. Clustering index example
- 2.2.11. Clustering Index (as pairs list)
- 2.2.11b. Secondary Index example
- 2.2.12. More indices
- 2.2.13. Indices
- 2.2.14. Query optimisation
- 2.2.15. Query processing
- 2.2.16. Query optimisation
- 2.2.16b. Query optimisation implementation
- 2.2.17. Query optimisation