Description of the illustration tgsql_vm_075.eps

This graphic shows a sales table on the left side. The table shows 6 rows as a vertical column, each with a ate ranging from May 18 to May 24. Corresponding to each date is a box labeled S1 to S6, with May 18 pointing to S1, May 19 pointing to S2, and so on. The boxes collectively point to a box containing the text "Global Statistics." Above this box is the text: "The database generates global statistics by aggregating partition-level statistics and synopses." The S7 box points to a cylinder labeled "Sysaux Tablespace."

Underneath the sales table is the text: "3. The table adds a new partition." Under the S7 box is the text: "4. The database gathers statistics and synopses for the new partition." Next to the S5 box is the text: "5. The database retrieves statistics and synopses for other partition." Next to the S1 box is the text: "6. The database generates global statistics by aggregating partition-level synopses."