ICE is a unique database system that automatically builds Knowledge Grid structures instead of requiring or using indices. Indices should be removed from your data model and data definition file (DDL). For more information on the ICE architecture and supported data types, see the infobright.org forums.

ICE supports standard MySQL DDL, but if your schema was for Oracle or SQL Server, there are possibly syntax or data types which are not supported. For more information, see:

mysql.com

ICE does not implement any referential integrity checks nor does it support DEFAULT values. The Infobright optimizer will accept these clauses, however, these clauses on the table definitions are ignored.