Re: CTX Indexes
- From: Sami Seerangan <dba.orcl@xxxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx
- Date: Wed, 25 May 2005 09:57:19 -0400
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@xxxxxxxxxxxxxxxxx> wrote:
> All,
>=20
>=20
> We are just creating CTX type indexes for the first time and I have a
> couple of questions.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
