*************************** 1. row *************************** id: 1 select_type: PRIMARY table: BA type: ref possible_keys: PRIMARY,PARENT_ID key: PARENT_ID key_len: 5 ref: const rows: 45562 r_rows: 93081.00 filtered: 100.00 r_filtered: 35.83 Extra: Using index condition; Using where *************************** 2. row *************************** id: 1 select_type: PRIMARY table: type: eq_ref possible_keys: distinct_key key: distinct_key key_len: 4 ref: func rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: *************************** 3. row *************************** id: 1 select_type: PRIMARY table: IBA type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: barsy_steni.BA.ARTICLE_ID rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: Start temporary *************************** 4. row *************************** id: 1 select_type: PRIMARY table: IBAD type: ref possible_keys: PRIMARY,ARTICLE_ID,KEY_ID,b_article_details_fk2 key: PRIMARY key_len: 8 ref: barsy_steni.IBA.ARTICLE_ID,const rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: Using where; Using index *************************** 5. row *************************** id: 1 select_type: PRIMARY table: IBADKV type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: barsy_steni.IBAD.DETAIL_ID rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: *************************** 6. row *************************** id: 1 select_type: PRIMARY table: IBAV type: ref possible_keys: PRIMARY,b_availability_fk2,AMOUNT_ARTICLE_IND,b_availability_ind02 key: AMOUNT_ARTICLE_IND key_len: 4 ref: barsy_steni.BA.ARTICLE_ID rows: 40 r_rows: 81.00 filtered: 100.00 r_filtered: 2.96 Extra: Using index condition; Using where; End temporary *************************** 7. row *************************** id: 1 select_type: PRIMARY table: type: ref possible_keys: key0 key: key0 key_len: 5 ref: barsy_steni.BA.ARTICLE_ID rows: 4 r_rows: 0.00 filtered: 100.00 r_filtered: 100.00 Extra: *************************** 8. row *************************** id: 3 select_type: MATERIALIZED table: b_article_cats type: index possible_keys: b_article_cats_fk1 key: BARSY_ID key_len: 4 ref: NULL rows: 88688 r_rows: 88718.00 filtered: 100.00 r_filtered: 100.00 Extra: Using index *************************** 9. row *************************** id: 2 select_type: LATERAL DERIVED table: TBAV type: ref possible_keys: PRIMARY,b_availability_fk2,AMOUNT_ARTICLE_IND key: AMOUNT_ARTICLE_IND key_len: 4 ref: barsy_steni.BA.ARTICLE_ID rows: 40 r_rows: 0.00 filtered: 100.00 r_filtered: 100.00 Extra: Using index condition