Re: Optimize index building

2004-09-13 Thread Egor Egorov
Haitao Jiang [EMAIL PROTECTED] wrote: We are using following steps to re-load and re-build a table every day: truncate the table disable index load data enable index What are the important parameters I should be watching out to make the ebale index step faster? Out table is over

Optimize index building

2004-09-10 Thread Haitao Jiang
Hi, We are using following steps to re-load and re-build a table every day: truncate the table disable index load data enable index What are the important parameters I should be watching out to make the ebale index step faster? Out table is over 10million rows and has two fulltext indexes.