RE: Index performance

From: Nicoll, Iain (Calanais) <iain.nicoll_at_calanais.com>
Date: Tue, 23 Jul 2002 10:23:43 -0800
Message-ID: <F001.0049FCEA.20020723102343@fatcity.com>

Also do you know what is the most selective part of the query. If you know that one index will bring back the fewest rows then try hinting to use it.

-----Original Message-----
Sent: Tuesday, July 23, 2002 5:59 PM
To: Multiple recipients of list ORACLE-L

why do you think hitting the indexes is a bad thing? what is the performance of this query? What's the explain plan?

• Seema Singh <oracledbam_at_hotmail.com> wrote:
  > Hi
  > I am executing following query adn this query hits a number of
  > indices on
  > this table.let me know what is wrong please.all in where clause are
  > having
  > indexes.
  > select name,last_access, reg_date from empmaster where emp_id<1000000
  > and reg_date>to_date('2001-01-01','YYYY-MM-DD') and
  > emp_st='valid' and last_access>to_date ('2001-01-01','YYYY-MM-DD')
  > and emp_status='S' and match='FIRST'
  > Here all conditions in where clause are having indexes.
  > How to rewrite this query.
  > The primary key is emp_id.
  > Thanks
  > -Seema
  >
  >
  >
  >
  >
  > _________________________________________________________________
  > Chat with friends online, try MSN Messenger: http://messenger.msn.com
  >
  > --
  > Please see the official ORACLE-L FAQ: http://www.orafaq.com
  > --
  > Author: Seema Singh
  > INET: oracledbam_at_hotmail.com
  >
  > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
  > San Diego, California -- Public Internet access / Mailing
  > Lists
  > --------------------------------------------------------------------
  > To REMOVE yourself from this mailing list, send an E-Mail message
  > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
  > the message BODY, include a line containing: UNSUB ORACLE-L
  > (or the name of mailing list you want to be removed from). You may
  > also send the HELP command for other information (like subscribing).
  

  ---

Do You Yahoo!?
Yahoo! Health - Feel better, live better http://health.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  INET: wisernet100_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nicoll, Iain (Calanais)
  INET: iain.nicoll_at_calanais.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Jul 23 2002 - 13:23:43 CDT