db Indexes

[manubhutani]

Hi Guru's

Can any body tell me whether we can see the indexes created by the system for a db table?

[Former Member]

hi Manu,

go the required table via SE11 and press 'Indexes' button to display the indexes that are already crated for that table ...

Regards,

Santosh

[manubhutani]

that is fine they are created by sap

but i have heard that system automatically created indexes based on primary keys

can we see that?

[Former Member]

Hi,

All the Primary keys of a table are the Primary indexes...You cannot see them..

For all the secondary indexes/creation of indexes, You can see in SE11->Index Button on the tool bar.

Regards

Shiva

[Former Member]

hi Manu,

In the index section it shows both the system created indexes and user created indexes ... You can create upto 9 secondary indexes ...

Primary key indexes can be viewed ... at it is define at runtime ...

Regards,

Santosh