Secondary index subtable

Database

Secondary index subtable

Hi ,

Will i be able to see the structure of a secondary index subtable ?

I just want to know the subtable columns .

Thank you,

5 REPLIES
Enthusiast

Re: Secondary index subtable

The structure will depend on the type of secondary index.

ie: USI/NPPI  , NUSI/PPI, etc

Check out Database Design documentation for your release.

Rglass

Enthusiast

Re: Secondary index subtable

If you show the base table, you will see the columns of the secondary indexes.

UNIQUE PRIMARY INDEX PK_TEST_RESULTS ( TEST_PROC_ID )

UNIQUE INDEX ( PAT_ID )

INDEX ( RESULT_DATE );

This example has a UPI, USI and NUSI.

Enthusiast

Re: Secondary index subtable

You can see "hints" about its' structure, as noted by the two previous posts, but you can't see or access the table directly.

Enthusiast

Re: Secondary index subtable

If you don't have permissions to access the base table, ask the DBA to show the table and you will have the SI's columns.

Assume you don't have select access on DBC.

Re: Secondary index subtable

Thank you :)