Reactive Index Design - Relational Database Index Design and the Optimizers - page 131

LRT

Synchronous read
87 × 9 ms = 1 s

SQL calls
210

8 s

Indexes:
Tables:

9
78

SQL Non -SQL

8 s 0 s

0 s 1 s 0 s 0 s 7 s

Wait for
prefetch

CPU time Sync

read

Lock
waits

Other
waits

Figure 7.12 An atypical spike.

EXERCISES

7.1. How would you classify the spike shown in Figure 7.12: a promising culprit, an
unpromising culprit, or a victim?
7.2. What can be done to reduce the local response time?