Re: Abfrage in einer Hierarchie

[Gerald Koch]

auch nicht viel schneller... 1,669 sekunden

kannst du damit was anfangen?

'1', 'PRIMARY', '<derived2>', 'ALL', NULL, NULL, NULL, NULL, '10', ''
'1', 'PRIMARY', 'i1', 'eq_ref', 'PRIMARY', 'PRIMARY', '8', 'i2.YP_INSTANCE_ID', '1', 'Using where'
'2', 'DERIVED', '<derived3>', 'ALL', NULL, NULL, NULL, NULL, '20', ''
'2', 'DERIVED', '<derived5>', 'ALL', NULL, NULL, NULL, NULL, '284', 'Using where'
'2', 'DERIVED', '<derived6>', 'ALL', NULL, NULL, NULL, NULL, '577', 'Using where'
'2', 'DERIVED', '<derived4>', 'ALL', NULL, NULL, NULL, NULL, '757', 'Using where'
'6', 'DERIVED', 'yp_ent_par_materialize', 'index', NULL, 'PRIMARY', '82', NULL, '703166', 'Using where; Using index'
'5', 'DERIVED', 'yp_ent_par_materialize', 'index', NULL, 'PRIMARY', '82', NULL, '703166', 'Using where; Using index'
'4', 'DERIVED', 'yp_ent_par_materialize', 'index', NULL, 'PRIMARY', '82', NULL, '703166', 'Using where; Using index'
'3', 'DERIVED', 'yp_ent_par_materialize', 'index', NULL, 'PRIMARY', '82', NULL, '703166', 'Using where; Using index'

ich probier gerade was mit group by/having... kommt aber nix zurück :-/