OpenSim-Test/OpenSim/Data/MSSQL/Resources/003_GridStore.sql

BEGIN TRANSACTION

CREATE NONCLUSTERED INDEX IX_regions_name ON dbo.regions
	(
	regionName
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

CREATE NONCLUSTERED INDEX IX_regions_handle ON dbo.regions
	(
	regionHandle
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]


CREATE NONCLUSTERED INDEX IX_regions_override ON dbo.regions
	(
	eastOverrideHandle,
	westOverrideHandle,
	southOverrideHandle,
	northOverrideHandle
	) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

COMMIT