CODEWITHSUNDEEP
databaseoracle-databasepartitioningdatabase-partitioning
Abhimanyu
Abhimanyu

Reputation: 695

does database partitioning require changes in application code?

I have an application written in Spring-boot , we have done with the optimization of the queries. We are thinking of database (Oracle database ) partitioning based on date. do we need to do any changes in our spring boot application or the oracle will handle things automatically.

Upvotes: 0

Views: 581

Answers (1)

user330315
user330315

Reputation:

No, it does not require changes to the application.

However partitioning is not the magical "make everything go faster" switch.

To make partitioning work properly as a performance improvement, your queries have to include the partitioning key in their where clause - otherwise partitioning might even make things slower.

So, if you queries already include the partitioning key, you don't need to change anything.

If the queries do not include the partitioning key, you need to add them to all queries that should make use of partition pruning for performance purposes.

Upvotes: 2

Related Questions