[spatial data] 공간인덱싱

msdn - 공간인덱싱 개요
https://goo.gl/1MTmEL

인덱싱 심화
https://goo.gl/BDXpsq

대한민국 위/경도 범위
https://goo.gl/Fx1rmr

Q : Spatial index statistics missing
https://goo.gl/Bo8Juk

인덱스 통계보기

declare c cursor static for
select object_id, name, index_id from sys.indexes where type_desc = 'SPATIAL'
open c
      declare @obj int
      declare @statsname varchar(max)
      declare @indid int
      declare @tname varchar(max)
fetch next from c into @obj, @statsname, @indid
while (@@fetch_status = 0)
begin
      declare @internaltablename varchar(max)
      declare @stmt varchar(max)
      fetch next from c into @obj, @statsname, @indid
      select top 1 @tname = name from sys.objects where object_id = @obj
      set @internaltablename = 'sys.extended_index_' + cast(@obj as varchar(max)) + '_' + cast(@indid as varchar(max))
    select 'Showing statistics for ', @tname
      select @stmt = 'dbcc show_statistics (''' + @internaltablename + ''', ''' + @statsname + ''')'
      exec (@stmt)
end
close c
deallocate c