Re: CTX Indexes

From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 26 May 2005 10:48:26 -0700
Message-ID: <bf463805052610482e00810c@mail.gmail.com>

Hi Connor,
Do you know what the consequences are of indexing the DR$ tables?

We have a new upgraded version of a COTS app that is preparing to go live. It comes with its very own routine for analyzing tables. ( it is just a call to dbms_stats.analyze_schema )

I've not worked too much with CTX, but as this upgraded version makes extensive use of it, looks like it is time to dig in.

Thanks,

Jared

On 5/25/05, Connor McDonald <mcdonald.connor_at_gmail.com> wrote:
>
> Just to add... optimizer stats on the DR$ tables that underpin your
> index is not supported until v10. (I logged a tar asking that very
> question a few weeks back).
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l

Received on Thu May 26 2005 - 13:53:14 CDT