Oracle Rowid when Enabling partitioned read

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
le thuong
Premium Member
Premium Member
Posts: 76
Joined: Wed Sep 09, 2009 5:21 am

Oracle Rowid when Enabling partitioned read

Post by le thuong »

We have a Select joining many tables with Oracle connector. When enabling partitioned read, we see that the number of records read is not constant.
When Partitioned read method = Rowid hash or Rowid round robin, the count is correct.
When Partitioned read method = Rowid range, the count is lower than what we expect.
I understand that the connector adds a where clause (on Rowid). Which table's rowid is taken when we have many tables ? Why the count is incorrect when Partitioned read method = Rowid range ?
Thuong

best regards
Post Reply