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

One Thought to “Optimizing star queries”

  1. … [Trackback]

    […] Read More to that Topic: techdatabasket.com/2019/03/14/optimizing-star-queries/ […]

Leave a Comment