Hi everyone. Im trying to write a program that executes queries in batch mode. The queries are given by users. The program must be able to know (aprox.) how many resources the query will use in order to:
1) Discard those queries that will consume too much resources (specially time)
2)Order the request so that the "lightest" queries are executed first
I think that the "EXPLAIN" command could help me to do this, but Im having problems interpreting the data contained in the EXPLAIN_* tables. Do you know any doc that explains how to query the EXPLAIN tables and also explains how to read the results?