Analyze Schema

Table of Contents



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



round-pushpin Analyzes the Stackoverflow:Posts schema and includes the physical page details.
ANALYZE SCHEMA WordList:Word WITH (IncludePhysicalPages = true)

Example Output
AnalyzeIndex.png


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