5.5 Designing a range index

This section explains what must be considered when designing a range index.

The CREATE INDEX statement is used to define range indexes.

Organization of this section

• 5.5.1 Points to consider when defining a range index

• 5.5.2 Estimating the number of pages for the global buffer used exclusively for range indexes

• 5.5.3 Pre-reading of range indexes

• 5.5.4 Notes on defining range indexes (unfinished status of range indexes)

To Page Top