2015-06-10 12:42:35 UTC
I am looking for real world experiences in the Informix community on reorging tables and rebuilding indexes. Specifically, what is the threshold and how does one find it? Our shop uses other RDBMS's and they are quite frequently doing both of these actions and also they run some sql that tells them the amount of fragmentation on indexes and tables. They also have the ability to do these actions online, which is obviously an advantage for not having to have things be offline.