Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@wildanm

wildanm/gist:3753594

Created September 20, 2012 02:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save wildanm/3753594 to your computer and use it in GitHub Desktop.
Save wildanm/3753594 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
+----+--------------------+-------+--------+--------------------------------------------------+---------------------------------+---------+------------------------------+--------+-----------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+--------------------+-------+--------+--------------------------------------------------+---------------------------------+---------+------------------------------+--------+-----------------------------------------------------+
| 1 | PRIMARY | NULL | NULL | NULL | NULL | NULL | NULL | NULL | Impossible WHERE noticed after reading const tables |
| 3 | DEPENDENT SUBQUERY | rh | ALL | PRIMARY | NULL | NULL | NULL | 430483 | Using where |
| 3 | DEPENDENT SUBQUERY | tc | eq_ref | PRIMARY | PRIMARY | 13 | tirtaerp.rh.ckode_from | 1 | Using index |
| 3 | DEPENDENT SUBQUERY | rd | eq_ref | PRIMARY,cash_d_index_idx | PRIMARY | 29 | tirtaerp.rh.cno_receipt,func | 1 | Using where; Using index |
| 2 | DERIVED | sh | range | PRIMARY,tbl_sales_h_index_idx,ckode_customer_idx | ckode_customer_idx | 14 | NULL | 127238 | Using where; Using temporary; Using filesort |
| 2 | DERIVED | sd | ref | tbl_sales_d_cnofaktur_index_idx | tbl_sales_d_cnofaktur_index_idx | 18 | tirtaerp.sh.cnofaktur | 1 | Using where |
+----+--------------------+-------+--------+--------------------------------------------------+---------------------------------+---------+------------------------------+--------+-----------------------------------------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment