oracle中查询效率优化.docVIP

Oracle中怎样提高查询效率（sql优化） 一、执行顺序及优化细则 1.表名顺序优化?(1) 基础表放下面,当两表进行关联时数据量少的表的表名放右边表或视图:?Student_info?? (30000条数据)Description_info (30条数据)??select *? from description_info di????? ,student_info???? si --学生信息表where si.student_id = di.lookup_code(+)?? and di.lookup_type(+) = STUDENT_ID??????与????select *? from student_info???? si--学生信息表????? ,description_info diwhere si.student_id = di.lookup_code(+)?? and di.lookup_type(+) = STUDENT_ID???以student_info作为基础表,你会发现运行的速度会有很大的差距。??????(2) 当出现多个表时,关联表被称之为交叉表,交叉表作为基础表select *? from description_info di??? ,description_info di2????? ,stude