DDL Glossary

• A
• Alter Configuration - Changing engine configuration parameters.
• Alter Index - Create and alter indexes to improve query performance.
• Alter Procedure - Create stored batches of pre-compiled and parameterized SQL statements.
• Alter Schema - Schemas are containers for other database objects.
• Analyze Index - Analyze or evaluate an indexes physical properties.
• Analyze Schema - Analyzes a schema for the purposes of evalue its storage distribution and partiton page fullness.
• C
• Create Index - Creates an index to speed up read operations.
• D
• DDL Glossary - A catalog of DDL related topics.
• E
• Exec - Exec is used to execute a stored procedure (system or user created).
• P
• PageSize - Defines the size of a schema page.
• Partitions - Partitions are applicable to indexes and define the number of pieces the index will be split into.
• R
• Rebuild Index - Rebuilds an index with a different set of parameters.
• T
• Transaction - Transactions provide your queries with an "all or nothing" approach to data modifications.