Speeding up a Spatial query

  • I'd be interested in seeing it too (unless you already sent it to me & I lost it, entirely possible). We've been getting great results with our indexes, but we have to build the queries pretty carefully.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • The Dixie Flatline (7/9/2010)


    Okay, thanks. I just sent you an email. Let me know if you got it.

    I'm taking it this isn't something you can share publicly since you emailed it to OP.

  • Lynn, the only reason I'm holding back is it is the subject of an article I'm writing (if it proves out against spatial indexes).

    One of the hangups I have about spatial indexes is how particular the query has to be, or how tailored the index has to be for certain queries. It seems to me that a more "generic" solution is desirable.

    I will gladly copy both you guys in, if you will give me some feedback.

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

  • The Dixie Flatline (7/9/2010)


    Lynn, the only reason I'm holding back is it is the subject of an article I'm writing (if it proves out against spatial indexes).

    One of the hangups I have about spatial indexes is how particular the query has to be, or how tailored the index has to be for certain queries. It seems to me that a more "generic" solution is desirable.

    I will gladly copy both you guys in, if you will give me some feedback.

    Sure, but I won't be quick on it. I'm a bit overcommitted through the first week of August.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • I don't think my service-level agreement with you specifies an instant response time, Grant 😉

    __________________________________________________

    Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
    Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills

Viewing 5 posts - 16 through 19 (of 19 total)

You must be logged in to reply to this topic. Login to reply