Is it possible to create spatial index on sql server 2008? If yes how do we create it on table with schemabinding?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
Unfortunately I don't believe you can. XML and Spatial Indexes can only be created tables. Not views.
Here's some proof for you straight from BOL: Restrictions on Spatial Indexes