RE: CTX Indexes

Sami,
>>We have to analyze
"have to"

Why?...Performance?

Thanks,

Chris Marquez

-----Original Message-----
From: oracle-l-bounce_at_freelists.org on behalf of Sami Seerangan Sent: Wed 5/25/2005 9:57 AM
To: Thomas.Mercadante_at_labor.state.ny.us
Cc: oracle-l
Subject: 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-l



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