Analyze Schema

Table of Contents

Overview

Examples:

Overview
Analyzes a schema for the purposes of evaluating its storage distribution and partiton page fullness. This information can be used to determine the proper page size for a given schema.

Optional parameters

IncludePhysicalPages = true or false

Examples:

Analyzes the Stackoverflow:Posts schema and includes the physical page details.

ANALYZE SCHEMA WordList:Word WITH (IncludePhysicalPages = true)

Example Output

Keywords - A breakdown of all high-level statements available via the query handler.