Oracle Rowid when Enabling partitioned read
Posted: Thu Nov 26, 2015 10:19 am
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 ?
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 ?