Dear MySQL-ians,
I am running a query on our database that join several tables. All tables have 2421500 rows and can be joined based on their id.
SELECT a.id, a.B_00_29, b.R_00_29, c.NIR_00_29, d.SWIR_00_29
FROM vgt.B as a INNER JOIN vgt.R as b using (id) INNER JOIN vgt.NIR as c using (id)
INNER JOIN vgt.SWIR as d using (id) INNER JOIN vgt.geo_1000 as f using (id)
INNER JOIN vgt.v_ecoclim as g using (id) INNER JOIN vgt.STATUS as h using (id)
WHERE f.X_coord > 1545 AND f.X_coord < 1570 AND f.Y_coord > 201 AND f.Y_coord < 223
AND h.STATUS_00_29 < 11 AND( g.v_lowreb = 9 OR g.v_lowreb = 20) AND g.v_landcov= 1
The query however takes a lot of time. Therefore I was wondering if anyone had suggestions to query more efficiently.
Thanx in advance!
Kind regards, Stef
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]