An optimization technique that enables the dimensions and fact tables in the star model to be accessed efficiently, and data returned to the user efficiently by ensuring that dimension data is visited first and fact data visited last and only once.