Opened 17 years ago
Closed 17 years ago
#237 closed enhancement (fixed)
SQLServer Spatial: optimize SELECT SpatialExtents() for performance
| Reported by: | danstoica | Owned by: | danstoica |
|---|---|---|---|
| Priority: | major | Milestone: | 3.3.0 |
| Component: | SQLServer Spatial | Version: | 3.3.0 |
| Severity: | 3 | Keywords: | |
| Cc: | External ID: |
Description
NOTE: SELECT COUNT(), SpatialExtents() is optimized.
Found that "select <column>.STEnvelope().STAsBinary() as MBR from <table>" is 3 times slower than straithforward "select <column>.STAsBinary() as MBR from <table>"
Note:
See TracTickets
for help on using tickets.
