Use The Index, Luke - SQL Indexing and Tuning e-Book
SQL indexing and tuning tutorial for developers. No unnecessary database details—just what developers need to know. Covers all major SQL databases.
Improving join-performance of SQL databases
An SQL query walks into a bar and sees two tables. He walks up to them and asks “Can I join you?” — Source: Unknown The join operation transforms data from a normalized model into a denormalized …
The annotated table of contents
What every developer should know about SQL performance
SQL vs NoSQL: what about other issues than ACID and scalibility?
In principle, SQL should provide tools to compensate for these challenges raised by normalization. Accessing data from many tables should be done using joins and similar operations of SQL.
Oracle execution plan operations - Use The Index, Luke
A short reference of the most common execution plan operations of the Oracle database.
Partial Objects in ORMs: loading a subset of properties
The hash join algorithm is good for large joins. Developers can reduce its memory footprint to make it even faster.
Clustered indexes are index-organized tables
The index-only scan executes an SQL statement using only the redundant data stored in the index. The original data in the heap table is not needed. If we take that concept to the next level and put all …
The most common database performance myths
Database performance myth clarified, explained and busted. In an attempt to thin out the dark woods of database performance myths, I list and explain some of the most common myth and misbeliefs here.
Slow Indexes in RDBMS - Use The Index, Luke
SQL queries might be slow even when using an index. Just because the database uses the index doesn’t mean it’s the best possible index for that query.
Who has to add the right indexes to an SQL database?
Database indexes must fit to the queries. Therefore, it has to be done by those writing the queries.