Matthew Leung
Jan 29, 2023

In oracle, there is sql profile, which can make a better query plan and fix it for the db optimiser, I found something similar in Postgres: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Optimize.html

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

Responses (1)

Write a response

Wow! I had no idea this was a thing, I'll definitely have to investigate this, thank you!

--