>> 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 -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
