Hi All, I am trying to intersection multiple sets of geographical data using ST_intersection function. But query execution time is long. My Query is : select st_intersection (st_intersection (t1.geometry, t2.geometry), t3.geometry) geometry from TEMP_OUTPUTTREE_2 t1,TEMP_OUTPUTTREE2_4 t2, TEMP_OUTPUTTREE_5 t3
I am having three table its having geometry data. I want to intersect operation on those data. Please suggest, Is there any optimal way to get the intersection with less execution time? Thanks Atul Kumar DISCLAIMER ========== This e-mail may contain privileged and confidential information which is the property of Persistent Systems Ltd. It is intended only for the use of the individual or entity to which it is addressed. If you are not the intended recipient, you are not authorized to read, retain, copy, print, distribute or use this message. If you have received this communication in error, please notify the sender and delete all copies of this message. Persistent Systems Ltd. does not accept any liability for virus infected mails.
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
