<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">How to use this optimization ?</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">select * </span><p
class="MsoNormal"><spanlang="EN-US">from table join partitioned_table on (</span><p class="MsoNormal"><span
lang="EN-US"> table.part_id = partitioned_table.id </span><p class="MsoNormal"><span lang="EN-US"> and
hash_func_mod(table.part_id)= hash_func_mod(partitioned_table.id)</span><p class="MsoNormal"><span
lang="EN-US">)</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span
lang="EN-US"> </span></div>