June 2018
Beginner to intermediate
210 pages
5h 12m
English
The common join is also called the reduce side join. It is a basic join in HQL and works most of the time. For common joins, we need to make sure the big table is on the rightmost side or specified by hit, as follows:
/*+ STREAMTABLE(stream_table_name) */
Read now
Unlock full access