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

5 Thoughts to “Optimizing star queries”

  1. … [Trackback]

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

  2. … [Trackback]

    […] Information on that Topic: techdatabasket.com/2019/03/14/optimizing-star-queries/ […]

  3. … [Trackback]

    […] Find More here on that Topic: techdatabasket.com/2019/03/14/optimizing-star-queries/ […]

  4. … [Trackback]

    […] Here you can find 11737 additional Info on that Topic: techdatabasket.com/2019/03/14/optimizing-star-queries/ […]

  5. … [Trackback]

    […] Find More here on that Topic: techdatabasket.com/2019/03/14/optimizing-star-queries/ […]

Leave a Comment