2007 Mar 27 7:48 AM
2007 Mar 27 7:49 AM
how many indexes can be created for a table?
2007 Mar 27 7:49 AM
2007 Mar 27 7:52 AM
tangirala,
There are two kinds of indexes. one is primary index and other one is secondary index.
primary index will be automatically created by the system.
but user has to define this secondary index.
Maximum of 15 secondary index is possible.(As per 21 days book).
but keep the secondary index as minimum as possible.
Regards...
Arun.
Reward points if useful.
2007 Mar 27 7:52 AM
Hi
Per table u can create maximum 510 index.
for detail
http://www.sapdb.org/sap_db_features.htm
Message was edited by:
Kalpana M
| User | Count |
|---|---|
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |