Subject | Table is fragmented? |
---|---|
Author | |
Post date | 2019-11-13T19:53:58Z |
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?