![]() ![]() Predicate Information (identified by operation id):ħ – access(«E».✽EPARTMENT_ID»=✽».✽EPARTMENT_ID»)Ģ select last_name, first_name, department_nameģ from hr.employees e, lateral ( select * from hr.departments d where e.department_id=d.department_id) | Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time | SQL> select * from table(dbms_xplan.display) ![]() Select last_name, first_name, department_name from employees e, departments d With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 – 64bit Production Según mis validaciones, a nivel del optimizador de la base de datos, no genera un cambio en la forma en como se PARSEA la instrucción, pero si, estéticamente se ve mucho mejor.Ī continuación encontrarán la forma tradicional de como escribir la consulta y la nueva sintaxis, utilizando la clausula LATERAL. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |