Examples for single-partition database environments

The following examples apply to single-partition database environments only. 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