Re: [GENERAL] Space wasted by denormalized data

2008-02-28 Thread Colin Wetherbee
Decibel! wrote: I wrote this query to identify how much space is being wasted in a database by denormalized data. For each field in each table, it calculates how much space the field is taking in it's table as well as indexes, then it calculates how much space would be needed if that field was

[GENERAL] Space wasted by denormalized data

2008-02-28 Thread Decibel!
I wrote this query to identify how much space is being wasted in a database by denormalized data. For each field in each table, it calculates how much space the field is taking in it's table as well as indexes, then it calculates how much space would be needed if that field was normalized into a se