Re: Where are the "unique" constraint indexes?

In article <3q00a8$m57_at_fg1.plk.af.mil> wilsons_at_mis4.plk.af.mil writes:
>When one creates a primary key or a unique constraint, an index is
>automatically created by the Oracle engine when that constraint is
>enabled. My question is can those indexes be "analyzed" and used by
>the cost based optimizer. Certainly I can't find them in dba_indexes.
 

They go into user_indexes. refer to appendix B in Oracle7 Server admin guide. I assume that they are used by the optimizer.

I'm not sure what effect Analyze Index has. I have observed that Analyze Index puts only one row into the INDEX_STATS table, replacing whatever row was there before. This implies to me that Analyze Index is not required or used by the optimizer.

Can anyone else explain more? I'm new at this.

Steve Cosner (stevec_at_zimmer.csufresno.edu) Received on Thu May 25 1995 - 00:00:00 CEST