Question about EXPLAIN output
Posted by:
eli cohen
Date: September 19, 2008 02:47PM
I have a query which does an "insert into .. select.." based on the query below. The ixlb index is a composite of (loaded,billable), and explain says that it's going to use it. However...in other queries, when an index is being used, I've seen in the "Extra:" section "Using index" in addition to the "Using where".
What's the significance of this? Does the lack of this in the below explain output indicate I could better optimize this query?
mysql> explain select * from transfer_table where loaded = 1 and billable = 1\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
table: transfer_table
type: ref
possible_keys: ixlb
key: ixlb
key_len: 4
ref: const,const
rows: 1261788
Extra: Using where
1 row in set (0.08 sec)
Cheers,
Eli
Subject
Views
Written By
Posted
Question about EXPLAIN output
3340
September 19, 2008 02:47PM
2173
September 19, 2008 09:40PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.