oracle and clickhouse are slow to perform join queries #23221
Unanswered
x826664567
asked this question in
Q&A
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
Oracle and clickhouse associated query, Oracle has 1 million data, clickhouse has 10,000 data, according to the code associated query, the query speed takes more than 10 seconds, trino version deployment is 440, according to the official website configuration requirements of a single deployment, how to optimize the query speed, the following is the execution of sql:
SELECT * FROM table_oracle.test.job_records internal JOIN table_clickhouse. test.job_records b
ON a.job_code = b.job_code
Beta Was this translation helpful? Give feedback.
All reactions