title: STcontains() query running slow even with Spatial Index
body: <p>I have one table called 'Region' which has got 2000 records. In the region table I have 1 geometry column called points. Now I have another table called Bus_Route with geometry column called 'geometry' with 10 million records.  Now I want the points which lie in that region. I am using the following query to see weather my point lies in that region or not by using STcontains. But this query is taking long time (around 3 days). I have created Spatial index on my Bus_Route table which has got 10 million records but that didn't help as well.</p>
  
  <pre><code>         Select
                Region.BlockID,
                Bus_Route.geometry
                from 
                Bus_Route,                         
                Region
             where 
  
                Region.points.STContains(Bus_Route.geometry) = 1
  </code></pre>
  
  <p>Please help!</p>