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@xxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l