This is an implementation of a SQL Query Optimizer application for Oracle Database using indexes and plans.
Tools : SpringBoot, Angular, Oracle19c, JdbcTemplate.
The home page of this application contains one button to open the sql textarea.
In order to optimize a query you just have to enter the query in the textarea.
The query we want to optimize already optimize so an alert message will show and tell you that and also the plan and the result of the query will show.
Now let's enter a query that need optimization:
The plan and the result of the query:
And this is the index we used to optimize the query and also we give the plan after optimization:
If we have a query used two columns of the table we have to add a multicolumn index like in this example:
The index and the plan after optimization:
If you enter a bad query an alert will show and tell you that we aren't able to analyse the query:
