> I have 5-10 billions rows in table, and insert 50,000 rows every hour.
> If so, I can not inactive index or spend a lot of time to reactive it.
> thanks.

What is your database page size?

Have you run gstat to look at the index stats for the table?


Sean