Ability to create indexes on temporary tables




  • Comment actions Permalink
    Official comment
    Nick Golovin

    Hello Un Sang, 

    thank you for your request. This feature is already supported by Data Virtuality: it is possible to define primary key on the temporary table during its creation, with one or several columns.

    For the primary key, also a clustered index will be created on the temporary table, which will speed up the operations on this table. 

    For more details, please see DV documentation at:

    Please note, that creating more than one index is not supported, and would not be easy to implement due to the internal implementation of temp tables. However, you can create more than one temp table with different indexes, or you can also create a temp table in your analytical storage. In the analytical storage you can also create several indexes on a table, if the underlying database supports it, by using either SYSADMIN.createIndex or dwh.native() calls. 

    I hope this information helps. 

    best regards,







  • 0
    Comment actions Permalink
    Un Sang Oum

    Hi Nick,

    Thank you for the info.  This helps.

    Un Sang Oum

Please sign in to leave a comment.

Powered by Zendesk