Re: Oracle wont use an index and performance sucks

From: Gjlinker <gjlinker_at_aol.com>
Date: 07 Feb 1999 18:26:45 GMT
Message-ID: <19990207132645.13258.00000003@ngol03.aol.com>

Dear all,

>Since we upgraded to 805 from 733 a month ago
>we have been having performance problems, not across every tbale but on
>certain specfic tables.

Oracle has re-implemented the optimizer in Oracle8. The optimizer did not work very well in Oracle7. My experience is that you can have a query like the one you described to use the index when no compute statistics is used. When you compute statistics it will start doing full table scans.

Oracle support told me that all should be fine in Oracle8. Apparently it isn't...

Regards Gerrit-Jan Linker,

---

*| Gerrit-Jan Linker : gjlinker_at_aol.com
*| 
*| http://members.aol.com/gjlinker

*| 
*| Developer of:
*| Oraxcel, OraWeb, OraSQL, OraCodes and OraDebug
*************************************************
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII  TTTTTTTTTTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT
LLLL      IIII      TTTT

LLLL

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

L Linker IT Consulting Ltd L

LLLLLLLLLLLLLLLLLLLLLLLLLLLL

Received on Sun Feb 07 1999 - 12:26:45 CST