hi every one i have 2 tables
table a this one a polygon layer with 10000 records
table b this one a point layer with 600000 records
in postgresql geodatabase i select a polygon feature with the query by input x and y
then i selected the one feature polygon i need to select point layer records that
intersect by the polygon feature but this query time 40 seconds and very slow please help me .
select shape from sde.table_b where st_contains((select shape from st_point(235116.084 ,2225686.917,10100) as tt , table_a where st_contains (table_a.shape,tt)='t'),shape)='t'point data is sample not really very thanks
أكثر...
table a this one a polygon layer with 10000 records
table b this one a point layer with 600000 records
in postgresql geodatabase i select a polygon feature with the query by input x and y
then i selected the one feature polygon i need to select point layer records that
intersect by the polygon feature but this query time 40 seconds and very slow please help me .
select shape from sde.table_b where st_contains((select shape from st_point(235116.084 ,2225686.917,10100) as tt , table_a where st_contains (table_a.shape,tt)='t'),shape)='t'point data is sample not really very thanks
أكثر...