Hi,
I have a table that is partitioned on a numeric column (ID).
Partitioning works when I query the table with no joins.
SELECT * FROM TABLE A a WHERE ID IN (SELECT ID FROM TABLE B b WHERE CREATED_TS = CURRENT_TIMESTAMP)
Partitioning doesn't work when I do join.
SELECT A.* FROM TABLE A a INNER JOIN TABLE B b ON a.ID = b.ID.
Is there any other option that would work.
Thanks in Advance..
