| Description |
CREATE SPATIAL INDEX index_name
ON <object> ( spatial_column_name )
{
[ USING <geometry_grid_tessellation> ]
WITH ( <bounding_box>
[ [,] <tesselation_parameters> [ ,...n ] ]
[ [,] <spatial_index_option> [ ,...n ] ] )
| [ USING <geography_grid_tessellation> ]
[ WITH ( [ <tesselation_parameters> [ ,...n ] ]
[ [,] <spatial_index_option> [ ,...n ] ] ) ]
}
[ ON { filegroup_name | "default" } ]
CREATE [ PRIMARY ] XML INDEX index_name
ON <object> ( xml_column_name )
[ USING XML INDEX xml_index_name
[ FOR { VALUE | PATH | PROPERTY } ] ]
[ WITH ( <xml_index_option> [ ,...n ] ) ]
spatial example:
CREATE TABLE SpatialTable (id int primary key, geometry_col geometry)
GO
CREATE SPATIAL INDEX spatialindex
ON SpatialTable(geometry_col)
WITH ( BOUNDING_BOX = ( 0, 0, 500, 200 ) )
xml example:
CREATE TABLE dbo.testtableindexxml ( id int NOT NULL, name varchar(25) NULL, colxml xml NULL,
CONSTRAINT pkind PRIMARY KEY(id))
ON [PRIMARY]
GO
CREATE PRIMARY XML INDEX textxmlindex ON dbo.testtableindexxml (colxml)
GO
these indexes will not show up under there tables, but will show up under all index folder, and if scripted will be all wrong...
|
CREATE SPATIAL INDEX index_name
ON <object> ( spatial_column_name )
{
[ USING <geometry_grid_tessellation> ]
WITH ( <bounding_box>
[ [,] <tesselation_parameters> [ ,...n ] ]
[ [,] <spatial_index_option> [ ,...n ] ] )
| [ USING <geography_grid_tessellation> ]
[ WITH ( [ <tesselation_parameters> [ ,...n ] ]
[ [,] <spatial_index_option> [ ,...n ] ] ) ]
}
[ ON { filegroup_name | "default" } ]
CREATE [ PRIMARY ] XML INDEX index_name
ON <object> ( xml_column_name )
[ USING XML INDEX xml_index_name
[ FOR { VALUE | PATH | PROPERTY } ] ]
[ WITH ( <xml_index_option> [ ,...n ] ) ]
spatial example:
CREATE TABLE SpatialTable (id int primary key, geometry_col geometry)
GO
CREATE SPATIAL INDEX spatialindex
ON SpatialTable(geometry_col)
WITH ( BOUNDING_BOX = ( 0, 0, 500, 200 ) )
xml example:
CREATE TABLE dbo.testtableindexxml ( id int NOT NULL, name varchar(25) NULL, colxml xml NULL,
CONSTRAINT pkind PRIMARY KEY(id))
ON [PRIMARY]
GO
CREATE PRIMARY XML INDEX textxmlindex ON dbo.testtableindexxml (colxml)
GO
these indexes will not show up under there tables, but will show up under all index folder, and if scripted will be all wrong...
|
