Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: CTX Indexes
Thomas,
We have to analyze
I_TABLE_CLAUSE,K_TABLE_CLAUSE,R_TABLE_CLAUSE,N_TABLE_CLAUSE and
I_INDEX_CLAUSE objects.
For example,
SQL> select index_type,index_name,last_analyzed from dba_indexes where index_name like '%TAXCATEGORYVALUE_VALUE%'; P_TABLE_CLAUSE=20
INDEX_TYPE INDEX_NAME LAST_ANALYZED --------------------------- ------------------------------ --------------- DOMAIN TAXCATEGORYVALUE_VALUE NORMAL DR$TAXCATEGORYVALUE_VALUE$X
SQL> analyze index HIBM_TAXONOMY.TAXCATEGORYVALUE_VALUE compute statistics;
=20
Index analyzed.
SQL> select index_type,index_name,last_analyzed from dba_indexes where index_name like '%TAXCATEGORYVALUE_VALUE%'; =20
INDEX_TYPE INDEX_NAME LAST_ANALYZED --------------------------- ------------------------------ --------------- DOMAIN TAXCATEGORYVALUE_VALUE NORMAL DR$TAXCATEGORYVALUE_VALUE$X
SQL> analyze index HIBM_TAXONOMY.DR$TAXCATEGORYVALUE_VALUE$X compute statis=
tics;
=20
Index analyzed.
=20
SQL> select index_type,index_name,last_analyzed from dba_indexes where
index_name like '%TAXCATEGORYVALUE_VALUE%';
=20
INDEX_TYPE INDEX_NAME LAST_ANALYZED --------------------------- ------------------------------ --------------- DOMAIN TAXCATEGORYVALUE_VALUE NORMAL DR$TAXCATEGORYVALUE_VALUE$X 25-MAY-05
On 5/25/05, Mercadante, Thomas F (LABOR)
<Thomas.Mercadante_at_labor.state.ny.us> wrote:
> All,
>=20 >=20
-- http://www.freelists.org/webpage/oracle-lReceived on Wed May 25 2005 - 10:02:06 CDT
![]() |
![]() |