ST_Intersects does not use spatial index

ا

المشرف العام

Administrator
طاقم الإدارة
I wrote this part of code:

SELECT CB.id_2 AS CountyID, CA.id_2 AS NeighbourCountyID FROM "Counties10B" CB,"Counties10" CAWHERE ST_Intersects(CA.geog,CB.geog);But it does not use spatial index. What could be a problem? Indexes are created on both table.





أكثر...
 
يجب تسجيل الدخول أو التسجيل كي تتمكن من الرد هنا.
أعلى