topic Re: primary index in Application Development and Automation Discussions

primary index

Former Member — Wed, 12 Sep 2007 09:27:19 GMT

Hi,

I have created one table(internal table) in se11 and also have assigned some fields are as primary keys.I know that when we define primary key for one field the system will create primary index for that as ' 0 '.now my question is how to see and use that key.

Regards,

Krishna.

Re: primary index

Former Member — Wed, 12 Sep 2007 09:32:50 GMT

hi krishna

Normally we will create indexes on transparent ztables...

for that one index tab is there to see the index no.s

in which column we created the indexesss...

in se11

Re: primary index

varma_narayana — Wed, 12 Sep 2007 09:36:45 GMT

Hi..

Primary Index is Created on the Primary key fields of the Table automatically when the Table is Activated.

Whenever we use the Select.. where clause on Primary key the Primary index is used by the system. We can't explicitly use indexes.

To Check whether a query is using index or not we can use SQL Trace ST05.

<b>reward if Helpful.</b>