Optimizing star queries

  • DBMS_XPLAN.DISPLAY
  • ALTER SESSION SET star_transformation_enabled=TEMP_DISABLE;

Database Administration -> Database PL/SQL Packages and Types Reference -> 202 DBMS_XPLAN
Database Administration -> Oracle Database Reference -> STAR_TRANSFORMATION_ENABLED

Related posts

Leave a Comment