Subject | Table is fragmented? |
---|---|
Author | |
Post date | 2019-11-22T16:42:03Z |
Recently I ran a "Database statistics" with ibexpert on one of our dbs, and there were a lot of tables marked in yellow, with the tooltip saying "Table xxx Is fragmented"
I couldn't quite find an explanation for it online, so I have a few doubts about it:
• Is this the same as index fragmentation?
• Is this something to be worried about?
• Does gfix or backup/restore fix the problem?
• How can I query the metadata to figure out if there are fragmented tables in my db?
Image : https://imgbbb.com/image/L5Lryy