Compare geometry
Hello,
I have an issue comparing two large spatial layers (tables). I would like to find changed parcels (geometry) in a region. I have a new table of parcels and need to compare to the old one. Both tables have approx. 10 millions of rows. And the problem here is that queries I've tested need more than 30 hours to complete. I know, it a lot of data, but maybe I missed something, so I would like to hear your suggestions/ideas.
Here are some queries I have tested:
1.)
SELECT n.region_id, n.parcel_id, SDO_EQUAL(n.geometry, s.geometry)
I have an issue comparing two large spatial layers (tables). I would like to find changed parcels (geometry) in a region. I have a new table of parcels and need to compare to the old one. Both tables have approx. 10 millions of rows. And the problem here is that queries I've tested need more than 30 hours to complete. I know, it a lot of data, but maybe I missed something, so I would like to hear your suggestions/ideas.
Here are some queries I have tested:
1.)
SELECT n.region_id, n.parcel_id, SDO_EQUAL(n.geometry, s.geometry)
0