[GENERAL] should I reindex the table of more than 10 millions rows regularly when more data are inserted?

Hi everyone, I have a big table (more than 10 millions rows) and create an index (three columns) ( the index is not created with creating the table). Within one day of the index created, the performance of query searching is ok. But with more than several thousands rows of data inserted

Re: [GENERAL] should I reindex the table of more than 10 millions rows regularly when more data are inserted?

2010/3/7 zxo102 ouyang zxo...@gmail.com Hi everyone, I have a big table (more than 10 millions rows) and create an index (three columns) ( the index is not created with creating the table). Within one day of the index created, the performance of query searching is ok. But with more