How to prohibit padding and activation Index How large insert padding (24 million records) before the ban Index, insert after activation index? Please experts advise. Interesting proposition should be some. Want to have the guidance of experts. . I have to look up the information center This is the model you want to load tools padding mode. If simply using insert, delete it first index rebuilt bar. Tried, table too, to restore deleted from the index after sharing a 40-minute, it will not, because there is such an order mysql, I would like to ask DB2 there are similar orders. ALTER TABLE tbl_name DISABLE KEYS; 4003rd ban Index ALTER TABLE tbl_name ENABLE KEYS; 4003rd activated Index Alter index indexname rebuild; 4003rd reconstruction Index Even after the opening of another ban renewal, the first time than after the introduction delete index data for a longer time after reconstruction. Since the database is the same as for the creation of new data inserted Index, which has often create indexes defend the indexing information may be longer. Insert retention index, the index of each record insertion are rebuilding, you have said that 40 minutes after the spread will expand n times were inserted in the article. You may do these : 1. Haar load from /dev/null of ixf replace into TABLENAME; Guangzhou Trade Fair This will help to clear all the data from the table in a short time 2. Drop index 3. Perform insert command to the input data or using load 4. Create index District DB2 table can function, a new exterior and first data loading, attach to their original form. But nuoran said that the index to a new record will be re-constructed. Not necessarily the number of provincial time. First revoke the authority of the index, after completing load grant [ Closed window ]