Re: OEM index tuning

From: Binley Lim <Binley.Lim_at_ird.govt.nz>
Date: Mon, 13 Aug 2001 17:28:44 -0700
Message-ID: <F001.003694E5.20010813171029@fatcity.com>

Afraid not - it produces some good results, and a lot of weird ones.

Bottom line is you still have to know what you are doing.

>>> andreaoracle_at_yahoo.com 08/14/01 09:50AM >>>
Hi all,

I run the OEM Oracle Expert for index tuning. It generates a script that I should drop some indexes, and build some indexes. Should I follow what OEM suggests? Is there an easy way to verify whether OEM's suggestion is corret? For example, OEM suggests to bulid index on table1 using col1 and col2. I tried to find a query search using col1&2 on T1, but didn't find any. (Where did OEM get the idea?)

Thanks, Andrea

---

Do You Yahoo!?
Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Andrea Oracle
  INET: andreaoracle_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: Binley Lim
  INET: Binley.Lim_at_ird.govt.nz

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 Mon Aug 13 2001 - 19:28:44 CDT