优化ORACLE查询SQL语句（Optimize the ORACLE query SQL statement）.docVIP

优化ORACLE查询SQL语句（Optimize the ORACLE query SQL statement） (1) select the most efficient table name order (valid only in the rule based optimizer): The Oracle parser in accordance with the order from right to left with a table in the FROM clause, the FROM clause written at the end of the table (based on table driving table) will be processed first, in the FROM clause contains multiple tables, you must select the number of records at the table as the base table. If you have more than 3 tables connected to the query, you need to choose the table table (intersection) as the base table, which refers