oracle - 在 Oracle 数据库中插入/更新数据时，JDBC Kafka Sink 连接器是否支持 Oracle 分区？

Question

我问是因为我将有一个处于“upsert”模式的接收器和分区的目标 Oracle 表。我想知道由于目标表中有数百万条记录，更新性能是否会很好。

标签： oraclejdbcapache-kafkaapache-kafka-connect

Answer 1

So long as you've set your table's partition key on the column that you're using for the incremental predicate (ID / timestamp) I don't see why Oracle won't be able to take advantage of partition pruning to improve the fetch performance—but this is on the Oracle and data model side, not something that's implemented by the connector.

The connector does not support anything like partition-exchange loading etc.