Re: Index or Primary key ??

Primary keys can be identified by looking in all_constraints (aka sys.dba_constraints). You can look up the index by name or by owner/table.

Primary keys are identified with a constraint_type of 'P'.

Patrick Suppes

nieuws net wrote:

> Good morning
>
> My goal is to automate the index sizing for production instances.
> When i look at the view USER_INDEXES there is no difference between
> the primary and the secondary index.
> In my mind you don't have store the primary key apart from data in a
> different tablespace.
> So my question is to you
>
> how do i distinct indexes from primary indexes with the help from a view ??
>
> thanks
>
> gkor_at_rdw.nl
Received on Fri Apr 23 1999 - 12:17:01 CDT