Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.server -> Re: Function Based Indexes with in clause?

Re: Function Based Indexes with in clause?

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 9 Aug 2002 03:53:28 -0700
Message-ID: <dee17a9f.0208090253.6cb2cb9e@posting.google.com>

Galen

Try building a histogram (default 75-ish buckets should be fine) on your indexed column and see if the CBO uses the index then...

Regards

Adrian Received on Fri Aug 09 2002 - 05:53:28 CDT

This message: [ Message body ]
Next message: Mohamed Ramadan: "ORA-25153: Temporary Tablespace is Empty"
Previous message: Dieter Stelzner: "New: Visual DBU - The database utility"
In reply to: Galen Boyer: "Re: Function Based Indexes with in clause?"
Next in thread: Galen Boyer: "Re: Function Based Indexes with in clause?"
Reply: Galen Boyer: "Re: Function Based Indexes with in clause?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US