Showing results for 
Search instead for 
Did you mean: 

Sybase IQ HG indexes

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (0)