Again those coming from Microsoft SQL Server will recognize FILLFACTOR syntax. IBM Informix also has a FILLFACTOR syntax that serves the same purpose as the SQL Server and PostgreSQL ones. For more details herePostgreSQL docs: Create Index. FillFactor basically creates page gaps in an index page. ...