1. A method for optimizing a snow flake query comprising: (a) creating a logical node comprised of a child dimension table and all dimension tables rooted at said child dimension table; and (b) determining commitment of said logical node for push down to a fact table;