Assertion: table's index | /r/HasProperty | created
Facets:
value: automatically
type: MANNER
Source sentences:
text: Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.
text: The primary index is created automatically when the table is created in the database.
text: Specifies the placement of FILESTREAM data for the table when a clustered index is created.
text: The IGNORE_DUP_KEY option applies only to insert operations after the index is created or rebuilt.
text: When the SET MIXED_PAGE_ALLOCATION option of ALTER DATABASE is set to TRUE, or always prior to SQL Server 2016 (13.x), when a table or index is created, it is allocated pages from mixed extents until it has enough pages to fill a uniform extent.
text: If ON is specified when a clustered index is added for a PRIMARY KEY or UNIQUE constraint, the whole table is moved to the specified filegroup when the clustered index is created.