Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: CTX Indexes
Peter,
Speaking of CTX_DDL.OPTIMIZE_INDEX, do you remember if I should run that procedure regularly or CTX_DDL.RESYNC_INDEX? Should I run them both?
Thanks
Tom
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of
Peter.Hitchman_at_thomson.com
Sent: Wednesday, May 25, 2005 9:53 AM
To: oracle-l_at_freelists.org
Subject: RE: CTX Indexes
Hi,
Well it has been a while, but back in 8.1.7 Oracle changed things so =3D
that the analyze did nothing, it only recorded the fact that it had been
=3D
run. The optimization method was changed to so that it was carried out =
=3D
at query time to find the token document count.
The object owned by ctxsys were not analyzed, but the =3D dr$<your_index_name>$I etc objects created in the application schema =3D that owned the text indices were analyzed. As well as a regular =3D CTX_DDL.OPTIMIZE_INDEX. Regards
Pete
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
(LABOR)
Sent: 25 May 2005 13:00
To: oracle-l
Subject: CTX Indexes
All,
=3D20
We are just creating CTX type indexes for the first time and I have a couple of questions.
=3D20
I know that I need to periodically resync the indexes using the Ctx_ddl package. We plan on doing this nightly for now until the apps folks tell us it needs to be done more often.
=3D20
I also tried to gather stats on the index, but the stats columns in the user_indexes view did not get updated. Is gathering stats on ctx type indexes a waste of time? Should I be gathering stats on some CTX tables instead - like the DR$INDEX_VALUE table where all of the data from the column is actually stored (this is a big assumption on my part)?
=3D20
Thanks
Tom
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 11:08:53 CDT
![]() |
![]() |