MySQL Forums
Forum List  »  Optimizer & Parser

optimize query?
Posted by: sam s
Date: April 16, 2011 09:41PM

Hi,

CREATE TABLE empcodes
(
eid VARCHAR(10),
ename VARCHAR(30),

INDEX idx_eid (eid),
INDEX idx_name (ename)
);

EXPLAIN SELECT name FROM empcodes WHERE eid = 44040\G
*************************** 1. row ***************************
id: 1
select_type: SIMPLE
type: ALL
possible_keys: idx_eid
key: NULL
key_len: NULL
ref: NULL
rows: 57769
Extra: Using where

Help how to tune the query.

Options: ReplyQuote


Subject
Views
Written By
Posted
optimize query?
3139
April 16, 2011 09:41PM
1034
April 17, 2011 10:59PM


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.