由于计算列，Azure SQL Server空间索引错误无法创建...

[更新]我尝试了下面的索引定义，并收到以下错误消息：

  Cannot create primary xml, selective xml or spatial index 'SI_Property' on table 'BTSOne.dbo.Properties', column 'Point', because the column is computed.

这是有道理的，但现在我回到正题。

我尝试这样做的原因？因为查询超时。我为所有其他查询设置了索引，但空间查询是执行查询的主要类型，但空间查询除外。

对于在哪个列上创建空间索引，我有些困惑。我很担心，因为某些记录缺少影响点列和索引列的经度和纬度值（默认为零）。起初我以为可以在点列上创建索引，但是阅读有关此问题的文章建议我使用多个列。我读得越多，就会变得越混乱。另外，还有正确设置网格的问题。经验法则似乎将它们设置得很高。

这些是相关的表列：

  [Latitude] [float] NULL CONSTRAINT [DF_Properties_Latitude]  DEFAULT ((0)),
  [Longitude] [float] NULL CONSTRAINT [DF_Properties_Longitude]  DEFAULT ((0)),
[Point]  AS ([geography]::Point([Latitude],[Longitude],[SRID])),
[SRID] [int] NULL CONSTRAINT [DF_Properties_SRID]  DEFAULT ((4326)),

这是存储过程的相关部分：

  DECLARE @SearchPoint as geography,
    @Region nvarchar(80)

  SET @SearchPoint = geography::Point(@Latitude, @Longitude, 4326)

  DECLARE @tempTable dbo.WorkingProperties

  SELECT [PropertyId] AS "Id", ISNULL([InnCode],'NA') AS "InnCode",  [UseName] AS "OfficeName", [Addr1] As "Address", [City]
  , [Zip] AS "PostalCode", [CountryCode], [Brand], [BrandCode] ,[Latitude],  [Longitude], 
  ([Point].STDistance(@SearchPoint)/1000) AS "Distance",
  NULL AS "ProjectType",'Properties' As "Source", [GlobalRMArea]
  FROM [BTSOne].[dbo].[Properties]
  WHERE [Point].STDistance(@SearchPoint) <= (@intRadiusKm * 1000)
  AND OpenStatus = 'Open'
  ORDER BY "Distance"

这就是我创建索引的方式：

  CREATE SPATIAL INDEX [SI_Property] ON [BTSOne].[dbo].[Properties]
  (
      [Point]
  )USING  GEOGRAPHY_GRID 
  WITH (GRIDS =(LEVEL_1 = HIGH,LEVEL_2 = HIGH,LEVEL_3 = HIGH,LEVEL_4 = HIGH),    
  CELLS_PER_OBJECT = 16, 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

我在非常有限的访问环境中工作，所以我没有太多尝试和错误的机会，而且我无法直接访问sql服务器实例，所以我不想浪费我的重试时间限制 ：-）。

谢谢！