question

pjkarthikmca avatar image
pjkarthikmca asked

datatype change

Im having table like 'TestTable' with 1.5Crores of records with some 18 indexes. TestTable has CHAR columns. So i need to change it to VARCHAR columns. So i am creating a new table TestTable_Stage table. My Question: when should i need to create indexes in TestTable_Stage After pushing the data from TestTable to TestTable_Stage or Before pushing the data from TestTable to TestTable_Stage Plz reply ASAP Regards, Karthik
bulk-insert
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DaveC avatar image DaveC ♦♦ commented ·
Moved to correct (default) space on site.
0 Likes 0 ·

1 Answer

·
Kev Riley avatar image
Kev Riley answered
Doesn't really matter in terms of the end result. Are any of the indexes UNIQUE - and is the source data clean?
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.