I have two line layers .i want to select data which are not intersecting. when i am writing this query it is taking a lot time.how i can make it faster and see result. SELECT Geometry into Qlayer5 FROM qlayer4, egmap_20170316_tmc_polyline where st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) = false and i have also tried using right join but none of them giving output. SELECT Geometry into Qlayer5 FROM qlayer4 Right join egmap_20170316_tmc_polyline on st_intersects(qlayer59.Geometry,egmap_20170316_tmc_polyline.geom) =false