Re: Insert problems on very large DB

[Roland Rabben]

Thanks, it looks like a solution for me. Need to do some more testing but early results show a big improvement in using DISABLE/ENABLE KEYS as opposed to DROP/CREATE INDEX.

The date colum is incremental. I guess I could split the large table in smaller tables containing records for each day in each table and then create a MERGE TABLE using all the underlying tables. But how do I index the the merge table. Do I create indexes on every underlying table, or do I create one index on the merge table?

If i have to create an index on the merge table, wont the index be the same size/length as the index for the large table any way?