to create indexing!!!

[paoli]

hi, i need to create additional indexing for a table.
Query:
Alter TABLE `banner` ADD INDEX `test_idx` ( `camp_id`,`is_unique`,`event_type`,`stamp` )
currently the record num:13573730
size: 1.2 GB
is there anyway to create indexing for this large table? plz help anyone!
Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Kodi]

Changing a table requires creating a new table with the new columns, indexes, etc., and copying the data across. For large tables this can be a time-consuming process. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --