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

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. T