Suck It Dry – Tuning Parallel Execution

setup4.sql This script is identical to setup3.sql but creates tables of 1,024,000 rows, resulting in ten data segments of 147 Mb by using PCTFREE 10 instead of PCTFREE 90. This means that fewer blocks are read in the early stages of query processing, but more data is passed between slaves, joined and sorted. ................
................

In order to avoid copyright disputes, this page is only a partial summary.