Re: Oracle's use of Indexes

Craig,

Just out of interest, what type of application is running on the database? I was just wondering why you were not using the plan stability features in 8i on your production database.

Regards,
Craig Munday.

At 05:45 AM 2/06/2003 -0800, Craig Healey wrote:
>OK, I'm confused. Maybe it's Monday morning and my brain's not working.
>We have a production schema and a test schema on the same Oracle 8.1.7
>instance, running on Windows. They both have a customer table, with 3
>million and 2 million records respectively. They both have the same
>indexes, and both have been analyzed today. Production used an index and
>took 40ms. Test didn't and took 20s. I played around, analyzing,
>dropping and creating indexes etc. Now neither of them use the index,
>both taking around 20s.
>I can add a hint, which works, but I want to know what changed.
>
>TIA
>
>Craig Healey
>
>
>**********************************************************************************
>
>This email and any files transmitted with it are confidential and intended
>solely
>for the use of the individual or entity to whom they are addressed and may
>contain
>confidential and/or privileged material. Any review, retransmission,
>dissemination
>or other use of, or taking of any action in reliance upon, this
>information by
>persons or entities other than the intended recipient is
>prohibited. Statements
>and opinions expressed in this e-mail may not represent those of the company.
>
>If you have received this email in error please notify
>system.administrator_at_hhsuk.com
>
>This footnote also confirms that this email message has been swept by
>MIMEsweeper
>for the presence of computer viruses (www.mimesweeper.com)
>
>***********************************************************************************
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Craig Healey
> INET: c.healey_at_hhsuk.com
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>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.net
-- 
Author: Craig Munday
  INET: cmunday_at_bigpond.net.au

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).