1. A method for optimizing a complex database query using a join-sequencing algorithm, said complex database query requested by an entity, said optimization method performing any of, or a combination of: a. multiple passes of said join-sequencing algorithm identifying multiple plans, with each of said passes performed using a different criterion for choosing a join in a sequence, wherein said plans are compared against a common measure to identify an optimal plan; and b. complex combinations of criteria by which said join-sequence algorithm selects the next join within a pass, wherein said complex combinations of criteria are used to identify an optimal plan; whereby said identified optimal plan is returned to said requesting entity.