My database is taking up a rather worrying amount of disc space. Admittedly it's got a lot of data in, plus indexes and other such things, but the size it's taking per, um, piece of data is more than i'd budgeted for.
Is there any way i can decompose the database file, and see what's taking the space? Are there any neat tricks to make it smaller without making it slower?
Check this article
http://www.ibphoenix.com/main.nfs?a=ibphoenix&l=;IBPHOENIX.KNOWLEDGEBASE;ID='426'