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]( https://community.denodo.com/docs/html/browse/6.0/vdp/vql/temporary_tables/temporary_tables#temporary-tables)” section of the Virtual DataPort VQL Guide and “[Indexes of Views](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/advanced_configuration_of_views/indexes_of_views#indexes-of-views)” section of the Virtual DataPort Administration Guide for more information.
Hope this helps!
