Skip to Content
Sep 12, 2018 at 07:38 AM

Sybase IQ HG indexes


Hello All,

We are going to move tables from IQ_SYSTEM_MAIN to IQ_USER_MAIN. And there are around 1000+ FP and HG indexes build on those tables.

I understood that while moving tables we need to take care of all the associated objects( indexes/metadata/views) .I need to understand below two points-

1) I believe FP indexes/Metadata/Views will be moved Automatically while running ALTER Table MOVE TO command.Am I correct Here?

2 )Does HG indexes will also be taken care automatically or we need to move it manually?

Anything else we need to take care while moving?

Thank You.