1
0

003_GridStore.sql 684 B

12345678910111213141516171819202122
  1. BEGIN TRANSACTION
  2. CREATE NONCLUSTERED INDEX IX_regions_name ON dbo.regions
  3. (
  4. regionName
  5. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  6. CREATE NONCLUSTERED INDEX IX_regions_handle ON dbo.regions
  7. (
  8. regionHandle
  9. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  10. CREATE NONCLUSTERED INDEX IX_regions_override ON dbo.regions
  11. (
  12. eastOverrideHandle,
  13. westOverrideHandle,
  14. southOverrideHandle,
  15. northOverrideHandle
  16. ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
  17. COMMIT