Subject Table is fragmented?
Author

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?