OEM index tuning

From: Andrea Oracle <andreaoracle_at_yahoo.com>
Date: Mon, 13 Aug 2001 14:19:04 -0700
Message-ID: <F001.00369327.20010813135023@fatcity.com>

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). Received on Mon Aug 13 2001 - 16:19:04 CDT