I am still trying, and I have run the EXPLAIN function over the query and I
have received the following result:
id select_type table type possible_keys key key_len ref rows Extra
1 PRIMARY tbl_f4Granjas index FK_ProjectHolderId 255 5 (null)
2 DEPENDENT SUBQUERY NULL NUL
Alvaro Cobo wrote:
Hi guys:
I am here again asking for your generous and wise advise:
I have a table (tbl_f4Granjas) with the information of some farms, their whole land extension (field: GraExtUPA) and the portion of the land they are managing in an agro-ecological way (field: GraExtPredio).