Re: Oracle don't want to use indexes

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 12 Aug 2007 19:21:56 +0200
Message-ID: <f9nfjj$3qk$1@news5.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Joseph wrote:
> Hi Folks!
>
> We have an oralce 9i that from 2 weeks seems to have troubles in
> performace. Seems that oracle don't want use indexes for 2 of our
> largest tables and many sql queries access in full table scan. what's
> happening?
>
> MAny Thanks
> BR
>

- - crystal ball broken
- - no version
- - no explain plan
- - not using indexes is not bad all the time.

-- Regards, Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFGv0G0Lw8L4IAs830RAsKfAJ9GV31deDq8ssRpvpLoRnADt1QiCgCeOV5u /TYvXesLVEVDGfRPQRfxLGw=
=arMQ
-----END PGP SIGNATURE----- Received on Sun Aug 12 2007 - 12:21:56 CDT