SQL QUERY OPTIMIZATION IN INFORMIX

Query operation is the most extensive operation in various database operations.So,query optimization is very important in the vast database.In making suitable indexes,setting appropriate conditions in the whereclause,creating temporary table for the optimizer of DBMS,the efficiency of the SQL queries can be improved.At the same time,many examples of query optimization in Informix are given.