|Home • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Creating a secondary index
By Neha Kapoor
There are two types of indexes: Primary index and
secondary index. Primary index is automatically created using the primary keys
Secondary index could be created as per the user requirement.
This article discusses about creating a secondary index.
Go to transaction SE11.
For our demo purpose, we have considered the table ZAUTHOR.
To know if there are any secondary indexes available, click
on Goto à
Following popup appears:
From the above screenshot, it is evident that there are no
secondary indexes already created.
Click on Create à Create Index
Enter the name of the index.
Fill in the details – Short description and the fields in
Save and activate.
Now you can observe the index created above in the list now:
Maximum number of secondary indexes we can have are 9.
How to make SELECT statement to make use of any particular secondary index? click here
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards