Digging the STAR_TRANSFORMATION_ENABLED parameter on Oracle database 12cR1 inside a PDB

When you think of a parameter that can help you out with star queries, this parameter is the STAR_TRANSFORMATION_ENABLED. According to the Oracle official documentation, it is described as the difference between a typical query and a star query, “A typical query in the access layer is a bond between the fact table and some number of dimension tables and is often referred to as a star query. In a star query, each dimension table is joined to the fact table using a primary key to foreign key join. Normally…

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 brunorsHi! I am Bruno, a Brazilian born and bred, and I am also a naturalized Swedish citizen. I am a former Oracle ACE and, to keep up with academic research, I am a Computer Scientist with an MSc in Data Science and another MSc in Software Engineering. I have over ten years of experience working with companies such as IBM, Epico Tech, and Playtech across…