MariaDB [artexdwh]> EXPLAIN EXTENDED select * from vw_orders_deals ;
+------+-------------+------------+--------+------------------------------------------------------------------------------+-------------------+---------+----------------------------+--------+----------+---------------------------------+
| id   | select_type | table      | type   | possible_keys                                                                | key               | key_len | ref                        | rows   | filtered | Extra                           |
+------+-------------+------------+--------+------------------------------------------------------------------------------+-------------------+---------+----------------------------+--------+----------+---------------------------------+
|    1 | PRIMARY     | <derived3> | ALL    | NULL                                                                         | NULL              | NULL    | NULL                       | 112518 |   100.00 |                                 |
|    1 | PRIMARY     | s          | ALL    | NULL                                                                         | NULL              | NULL    | NULL                       | 15     |   100.00 | Using where                     |
|    1 | PRIMARY     | d          | ref    | deal_origin_id_idx,deal_stage_id_idx,deal_company_id_idx,deal_contact_id_idx | deal_stage_id_idx | 303     | dwh.s.status_key           | 4503   |    49.06 | Using where                     |
|    3 | DERIVED     | p          | ALL    | order+product                                                                | NULL              | NULL    | NULL                       | 112518 |   100.00 | Using temporary; Using filesort |
|    3 | DERIVED     | o          | eq_ref | PRIMARY                                                                      | PRIMARY           | 12      | web.p.order_id,const       | 1      |   100.00 |                                 |
+------+-------------+------------+--------+------------------------------------------------------------------------------+-------------------+---------+----------------------------+--------+----------+---------------------------------+
5 rows in set, 1 warning (0.003 sec)