cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to Create Index on Global Temporary Table in SAP HANA cloud sps 04

seyfeddine
Discoverer
0 Kudos

I'm encountering an issue when attempting to create an index on a global temporary table within SAP HANA. My intention is to enhance the performance of queries that utilize this table, but I've hit a snag with the following error:

Error: (dberror) [7]: feature not supported: Cannot create index on temporary table: GLOBAL_PURCHASING_DOCUMENTS: line 19 col 63 (at pos 62)

The command I attempted to execute was:

CREATE INDEX GLOBAL_PURCHASING_DOCUMENTS ON GLOBAL_PURCHASING_DOCUMENTS(Purchasing_Document_ID);

  1. Is there a workaround or an alternative approach to optimize query performance on  temporary tables in SAP HANA?
  2. Are there best practices for managing large datasets in global temporary tables that might help mitigate the need for an index?
  3. Could this limitation be version-specific, and if so, are there any updates or configurations that might allow for index creation on temporary tables?

I appreciate any insights or recommendations you may have on how to effectively manage and query large temporary tables in SAP HANA.

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
Like the error message say, creating an index on a global temporary table in SAP HANA is not supported. But there are several ways to optimize query performance on temporary tables in SAP HANA, like partition the table to improve query performance, etc..

Accepted Solutions (0)

Answers (0)