1. A computer-based method for determining the optimum join sequence for processing a query having a plurality of tables from a relational database stored in an electronic storage device having a database management system, the method comprising the steps of: (a) a first pass for determining an optimum join sequence for joining the plurality of tables from the query; and (b) a second pass for using the optimum join sequence for creating a lowest cost access path plan for processing the query.