14. One or more non-transitory computer-readable storage media storing sequences of instructions which, when executed by one or more processors, cause: storing a query that references multiple tables analyzing operations the query specifies on the multiple tables to detect at least one of: two particular tables of the multiple tables could be dimension tables by detecting a join of the two particular tables of said multiple tables that does not comprise an equijoin, or one or more particular tables of the multiple tables could be fact tables by detecting at least one of: a minimum operation, a maximum operation, an average operation, a summation operation, an online analytical processing (OLAP) function based on a table of said multiple tables, or a group by operation based on multiple columns of a table of said multiple tables; identifying one or more candidate dimension tables of the multiple tables at least in part by determining, based at least in part on content of the query, that a particular candidate fact table of the multiple tables appears in one or more equijoins with the one or more candidate dimension tables; based at least in part on determining which of the multiple tables could be fact tables, generating an execution plan for the query, the execution plan operating on the particular candidate fact table and the one or more candidate dimension tables; wherein the execution plan, when performed, processes at least some data from at least one dimension using at least one of the one or more candidate dimension tables before processing at least some data from the particular candidate fact table.
14. One or more non-transitory computer-readable storage media storing sequences of instructions which, when executed by one or more processors, cause: storing a query that references multiple tables analyzing operations the query specifies on the multiple tables to detect at least one of: two particular tables of the multiple tables could be dimension tables by detecting a join of the two particular tables of said multiple tables that does not comprise an equijoin, or one or more particular tables of the multiple tables could be fact tables by detecting at least one of: a minimum operation, a maximum operation, an average operation, a summation operation, an online analytical processing (OLAP) function based on a table of said multiple tables, or a group by operation based on multiple columns of a table of said multiple tables; identifying one or more candidate dimension tables of the multiple tables at least in part by determining, based at least in part on content of the query, that a particular candidate fact table of the multiple tables appears in one or more equijoins with the one or more candidate dimension tables; based at least in part on determining which of the multiple tables could be fact tables, generating an execution plan for the query, the execution plan operating on the particular candidate fact table and the one or more candidate dimension tables; wherein the execution plan, when performed, processes at least some data from at least one dimension using at least one of the one or more candidate dimension tables before processing at least some data from the particular candidate fact table. 16. The one or more non-transitory computer-readable storage media of claim 14 , wherein determining which of the multiple tables could be fact tables does not include accounting for sizes of the multiple tables.