|< < 4 > >|

Query Optimization Practice

Data

R:

  • 10M rows
  • a: 10 values, uniformly distributed
  • b: 1M values, each occurs 10 times.
  • c: 5M values, each occurs 2 times.
  • s_id: points to random row of S.
  • r_filler: 100 bytes.

S:

  • 1M rows
  • d: 10K values, each occurs 100 times.
  • e: 100K values, each occurs 10 times.
  • f: 100 values, uniformly distributed.
  • t_id: one-to-one relationship with T.
  • s_filler: 100 bytes.

T:

  • 1M rows
  • g: 10K values, each occurs 100 times.
  • h: 100K values, each occurs 10 times.
  • t_filler: 100 bytes.

|< < 4 > >|