Re: [idea] table partition + hash join

On Wed, Jun 10, 2015 at 8:48 PM, Rosiński Krzysztof 2 - Detal
<Krzysztof.Rosinski2@orange.com> wrote:
> How to use this optimization ?
>
>
>
> select *
>
> from table join partitioned_table on (
>
>   table.part_id = partitioned_table.id
>
>   and hash_func_mod(table.part_id) = hash_func_mod(partitioned_table.id)
>
> )
>

If I read the proposed idea correctly, you wouldn't need to add that
second condition.

Thanks,
Amit