| ==== | |
| ---- QUERY: primitive_broadcast_join_1 | |
| -- Description : Selective broadcast join between lineitem and supplier. | |
| -- Target test case : Basic BI query with simple aggregation and highly selective join, | |
| -- and 99% of lineitem rows are filtered out by the created BitMapFilter. | |
| SELECT /* +straight_join */ count(*) | |
| FROM lineitem | |
| JOIN /* +broadcast */ supplier ON l_suppkey = s_suppkey | |
| AND s_name='Supplier#001880004'; | |
| ---- RESULTS | |
| ---- TYPES | |
| ==== |