*************************** 1. row *************************** id: 1 select_type: PRIMARY table: type: ALL possible_keys: distinct_key key: NULL key_len: NULL ref: NULL rows: 88688 r_rows: 87067.00 filtered: 100.00 r_filtered: 100.00 Extra: *************************** 2. row *************************** id: 1 select_type: PRIMARY table: BA type: eq_ref possible_keys: PRIMARY,PARENT_ID key: PRIMARY key_len: 4 ref: barsy_steni.b_article_cats.ARTICLE_ID rows: 1 r_rows: 1.00 filtered: 50.00 r_filtered: 38.23 Extra: Using where *************************** 3. 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.b_article_cats.ARTICLE_ID rows: 40 r_rows: 81.00 filtered: 100.00 r_filtered: 100.00 Extra: Using index condition; Start temporary *************************** 4. row *************************** id: 1 select_type: PRIMARY table: IBA type: eq_ref possible_keys: PRIMARY key: PRIMARY key_len: 4 ref: barsy_steni.b_article_cats.ARTICLE_ID rows: 1 r_rows: 1.00 filtered: 100.00 r_filtered: 100.00 Extra: *************************** 5. 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 *************************** 6. 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: 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.b_article_cats.ARTICLE_ID rows: 4 r_rows: 1.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: 81.00 filtered: 100.00 r_filtered: 100.00 Extra: Using index condition