/*
    INDEXES for db_tplus_maps withOUT geometry suppport (SQLSERVER 2005)

*/

USE [db_tplus_maps]
GO

/* indexes for the cities**/
CREATE CLUSTERED INDEX [IX_t_maps_cities_HtmId] ON [dbo].[t_maps_cities]
(
	[HtmID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [PK_t_maps_cities_id] ON [dbo].[t_maps_cities]
(
	[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

