CREATE  INDEX [IDX_NAME] ON [dbo].[TIGER_01]([FEDIRP], [FENAME], [FETYPE], [FEDIRS])
GO
 CREATE  INDEX [IDX_ZIP] ON [dbo].[TIGER_01]([ZIPL], [ZIPR])
GO
 CREATE  INDEX [IDX_TOLAT] ON [dbo].[TIGER_01]([TOLAT]) 
GO
 CREATE  INDEX [IDX_FRLAT] ON [dbo].[TIGER_01]([FRLAT]) 
GO
 CREATE  INDEX [IDX_FRLONG] ON [dbo].[TIGER_01]([FRLONG])
GO
 CREATE  INDEX [IDX_T2_TLID] ON [dbo].[TIGER_02]([TLID]) 
GO