Examples for partitioned database environments

The following examples apply to partitioned database environments only. They were produced on an RS/6000 SP machine with 7 physical nodes using inter-partition parallelism. Start with Query 1 and work through the examples in sequence. A discussion at the beginning of each example highlights what has changed from the previous example. You can also follow along interactively using the sample snapshots provided.

Query 1

Running a query with no indexes and no statistics

Query 2

Collecting current statistics for the tables and indexes in a query

Query 3

Creating indexes on columns used to join tables in a query

Query 4

Creating additional indexes on table columns