topic Re: db Indexes in Application Development and Automation Discussions

db Indexes

manubhutani — Fri, 25 Apr 2008 08:16:18 GMT

Hi Guru's

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

Former Member — Fri, 25 Apr 2008 08:18:37 GMT

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 — Fri, 25 Apr 2008 08:23:25 GMT

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 — Fri, 25 Apr 2008 08:26:14 GMT

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

Former Member — Fri, 25 Apr 2008 08:28:13 GMT

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