on 09-12-2018 8:38 AM
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.
User | Count |
---|---|
75 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.