Database: informixsql: select * from table1 left join out table2 left join out table3 where column> =: Date_From and color <=: Date_to
After improvement: Select * from table1 left join out table2 left join out table3 where column betWeen: Date_From and: Date_to
RESULTS: Tabel1 ~ Table3 is 140,000 data
Improvement: 10 minutes later: 4 minutes
