You can translate the question and the replies:

Index a temporary table

Hello, Can I index a temporary table columns, if so how can I do that. Thanks
20-03-2018 21:16:05 -0400

1 Answer

Hi, In Denodo Platform, the user can define indexes for the base views. For the base views created over JDBC data source, the indexes are automatically imported from the underlying source database. Whereas the indexes defined for the base views will be propagated directly to its derived views. As the temporary tables in Virtual DataPort Administration are not managed graphically, you could access them only from the VQL shell. Also, the temporary table would live until the session to the corresponding database remains open for the user created the temporary table. You could refer to the “[Temporary Tables](” section of the Virtual DataPort VQL Guide and “[Indexes of Views](” section of the Virtual DataPort Administration Guide for more information. Hope this helps!
Denodo Team
22-03-2018 08:24:47 -0400
You must sign in to add an answer. If you do not have an account, you can register here