I recently stumbled upon a situation where my index was much larger than
my table, does anybody have a query I can use to find ther similiar situations.

This needs to work for all combinations of partitoned and non partioned
tables and indexes