|
Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com |
EXPLAIN dies with an error
From: Andris Spruds (litrema
apollo.lv)
Date: Tue Apr 20 2004 - 16:36:13 CDT
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]