Prior to indexing a table properly, the optimization of data
types to ensure that sufficient storage is allocated is important.
In addition, when comparing column of 2 different tables, the
columns should designed to have the same data types.
This further improves the performance of SQL E which was
improved through properly indexing. As a result, a
performance improvement of around 95% overall was
observed.