Hi Bob, I did play with the
densities and levels of the spatial indices, and was able to steadily improve my procedure query time till i got one that was pretty fast. I could see dramatic differences in performance depending on the configuration of the index that my hint was pointing at. However I could never get the query optimizer to choose any of the indexes without a hint. I did try your ...