02-24-2007 12:33 PM
Dear friends,
can we create index on clustered table ?
madan
02-24-2007 7:45 PM
02-25-2007 10:49 PM
02-26-2007 12:09 PM
<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.
02-27-2007 5:55 AM
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.