RE: Oracle's use of Indexes

>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
>

Craig,

   Does 'etc' include doing something to tables as well? I would, from your posting, being tempted to say 'no'. Could it have anything to do with histograms ? The only thing I can currently think of is differences in the way statistics were gathered.

Regards,

Stephane Faroult
Oriole

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriolecorp.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).