primary index

[Former Member]

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.

[Former Member]

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

[varma_narayana]

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>