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.
Subject
Views
Written By
Posted
optimize query?
3196
April 16, 2011 09:41PM
1070
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.