Dear MaxDB list, The query "EXPLAIN SELECT l.*, m.measurement, m.date_taken FROM dbc_measurements m, dbc_lakes l WHERE m.date_taken = (SELECT MAX(date_taken) FROM dbc_measurements m2 WHERE m2.lake_id = m.lake_id AND m2.param_id=m.param_id) AND m.param_id=41 AND m.lake_id=l.id ORDER BY m.measurement DESC"
returns [-9205]: System error: AK Catalog information not found:FF000019023F0220008100000000000000000000000000000000000000000000000000 00000000000 The problem is that the query itself takes at least 5 seconds to execute, and I would like to optimize the tables so that it runs faster. But the EXPLAIN statement dies with an error. Am I doing something wrong? The MaxDB manual does not contain any useful information on the beforementioned error message. With best regards, Andris Spruds -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
