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>"

Change History (1)

comment:1 by danstoica, 17 years ago

Resolution: fixed
Status: newclosed
Note: See TracTickets for help on using tickets.