When execute an update command that the new data is large than the previous data, how does the DBMaker do?
If the rest page space can contain new data, DBMaker will delete old data first then put new data in the same page position, if rest page space is not enough, DBMaker will delete old data first and set new data becoming an indirect data then. The indirect record needs more I/O and may cause performance down,to avoid generating indirect data, setting the proper FILLFACTOR when you creating table.