| SQL adaptation guide for IBM Netezza 6.x / Data dictionary | |
Like most database servers, Informix® supports index creation on table columns. Indexes can be used to make the server find rows rapidly:
CREATE INDEX cust_ix1 ON customer (cust_name)
Netezza® does not support index creation on tables. There is no need for indexes in a Netezza database because performance is achieved by distributing data rows over several disks. Netezza tracks min/max values of each column per disk extent to ignore extents which do not contain the values the query is looking for. See Netezza documentation for more details.
You must remove all CREATE INDEX instructions from your programs and SQL scripts that create database tables.