>> CREATE INDEX ix1 ON temp.a (field1)
>> //
>> ---- Error -------------------------------
>> to Commit: On, SQL Mode: Internal, Isolation Level: Committed
>> Syntax error or access violation;-5001 POS(26) Missing privilege:INDEX.
>> create index ix1 on temp.a (field1)
>This is a feature because SAP DB doesn't allow indexes on temp tables.
If not present already, could you add this to the feature request list for a
future version? It would be a nice performance enhancement for people
working with large temporary tables.
Thanks
David
>Best regards,
>Holger
>SAP Labs Berlin
