Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

primary index

Former Member
0 Kudos
72

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.

2 REPLIES 2

Former Member
0 Kudos
46

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
Active Contributor
0 Kudos
46

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>