[dev.icinga.com #10066] Missing indexes for icinga_endpoints* and icinga_zones* tables in DB IDO schema #3361
This issue has been migrated from Redmine: https://dev.icinga.com/issues/10066
Created by tgelf on 2015-09-01 12:33:42 +00:00
It's a new feature and rarely used, still tables should get meaningful indexes.
2016-06-22 10:56:24 +00:00 by mfriedrich 7f56a04
The text was updated successfully, but these errors were encountered:
Updated by mfriedrich on 2016-06-22 10:49:36 +00:00
The first entry would use the index, but it seems that MySQL assumes a full table join and doesn't use the index here. Same goes for the endpoint tables.