/sql-query-optimizer

Implementation of a SQL Query Optimizer Application for Oracle Database using indexes and plans.

Primary LanguageJava

SQL Query Optimizer

This is an implementation of a SQL Query Optimizer application for Oracle Database using indexes and plans.

Tools : SpringBoot, Angular, Oracle19c, JdbcTemplate.

Table of contents

Application Demo

Application Demo

Home Page

The home page of this application contains one button to open the sql textarea.

1

Optimized Query

In order to optimize a query you just have to enter the query in the textarea.

1

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.

1

1

Optimizing a Simple Query

Now let's enter a query that need optimization:

1

The plan and the result of the query:

1

1

And this is the index we used to optimize the query and also we give the plan after optimization:

1

Multicolumn Index

If we have a query used two columns of the table we have to add a multicolumn index like in this example:

1

The index and the plan after optimization:

1

Bad Query

If you enter a bad query an alert will show and tell you that we aren't able to analyse the query:

1

Creators