SQL Performance (MOSC)

MOSC Banner

Large Table join performance

in SQL Performance (MOSC) 7 commentsAnswered

Hi all.

I need to create a table joining two large table, one approx 1.9 billion rows, the other about 6 billion rows (300 and 800 GB respectively). The resulting table is close to 6 billion rows.

Platform is Oracle RDBMS version 19.0 ant the instance is optimized for transactional use.

The first table and the destination table are partitioned, the second is not, and there is no reference in the large table that could be used to take advantage of the partitioning.

I am using a PL/SQL loop, creating each time a new table, joining few partition of the first table with the large table. After creation, I move all the partition to destination table (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center