Analyze Schema

Table of Contents

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:
round-pushpin Analyzes the Stackoverflow:Posts schema and includes the physical page details.
ANALYZE SCHEMA WordList:Word WITH (IncludePhysicalPages = true)

Example Output
AnalyzeIndex.png

Related