Use the Index, Luke – SQL Indexing and Tuning
6 hours ago
- #SQL
- #Indexing
- #Database Performance
- SQL indexing is the most effective tuning method but often neglected during development.
- Use The Index, Luke is a free web-edition explaining SQL indexing from the ground up, covering ORM tools like Hibernate.
- The site provides vendor-agnostic SQL indexing information with product-specific notes for Db2, MySQL, Oracle, PostgreSQL, and SQL Server.
- Key topics include the anatomy of an index, the B-Tree structure, slow indexes, and indexing for search performance.
- Other topics covered are indexing for joins, sorting, grouping, and the impact of indexing on DML operations like insert, delete, and update.
- The site also discusses partial indexes, NULL handling, and performance considerations like data volume and system load.