Continuing with Data-Clusters


Today’s installment covers the first two parts from Chapter 5, „Clustering Data. It explains the “cluster” term and demonstrates the impact of clustering data with a simple example.

This will be the basis for the next installment, which explains why adding another where clause may slowdown statement execution. Not just a little bit, but by factors. That is actually the question that has the highest failure rate at the 3 minute test.

Recent Questions at Ask.Use-The-Index-Luke.com

0
votes
1
answer
278
views

Updating multiple rows using a subquery in SQL

Jan 08 at 09:52 Jan 26
subquery update sql
1
vote
1
answer
210
views

Should 'id' (the primary key) be included in an index

Jan 03 at 15:24 Jan 26
index include
0
votes
1
answer
227
views

Best index for a multiple join-tables and filter

Jan 03 at 14:31 Markus Winand ♦♦ 216
index join where