hi
no you cannot..
Cheers,
Hakim
<b>Index maintenance is only possible for transparent tables.</b>
To make sure, go to any Cluster table and click Indexes button on the Application Toolbar.
You will get the below error message.
Index maintenance only possible for transparent tables
Message no. AD 807
Diagnosis
The specified table is not a transparent table.
Procedure
Only tables of type TRANSP can have a secondary index. Check the table type.
hi madan,
we're not authorized to create indexex on clustered or pooled tables since they are taken care off by SAP. If any modifications required on these tables, permission or authorization needs to be taken from SAP. That's what SSCR(SAP SOURCE CODE REGISTRATION). Also, these tables can not be buffered.
regrds,
shamim.
Add a comment