These suggestions are written for a technical audience and covers in detail what types of database queries are optimized for ICE.

ICE is a data storage engine with proprietary compression, storage, and retrieval methods. It leverages many features of MySQL including a support for variety widely-used APIs (e.g. SQL, ODBC, JDBC).

Best performance can be achieved when Infobright executes SQL statements by using its query optimizer. When a query cannot exploit Infobright’s proprietary retrieval methods, the query will invoke the MySQL database optimizer. In these cases, users should expect the query to perform as it would using the MySQL database engine itself.

For more information see Optimizing Queries.