Query optmizer

A query optimizer based using some heuristics.

Requirements

• node.js

Setup

1. Clone the repo

git clone https://github.com/isthatME/Query-optmizer.git

2. Install NPM packages

npm install

3. Run the project

ng serve

Example of an optimized query

Given the following query

SELECT USUARIO.NOME, USUARIO.CEP,NUMERO  FROM  USUARIO  
 JOIN CONTAS       
 ON CONTAS.USUARIO_IDUSUARIO = USUARIO.IDUSUARIO      
 WHERE NUMERO > 10 AND BAIRRO = CENTRO    ORDER BY BAIRRO, NUMERO, NOME

The result will be