DBMS-Specific Indexing Restrictions - Relational Database Index Design and the Optimizers - page 233

DB2 for LUW

CREATE [UNIQUE] INDEX index_name [CLUSTER]
ON table (column1 [DESC], column2 [DESC]...)
[INCLUDE (columna, columnb...)]
PCTFREE n

Pagesize 4K, 8K, 16K or 32K
Max 16 index columns
Max 1024 data bytes

Oracle

CREATE [UNIQUE] INDEX index_name
ON table (column1, column2...)
PCTFREE n

or function

Option: Index-organized table
Leaf pages = table

Pagesize (DB_BLOCK_SIZE) 2K, 4K, 8K, 16K, 32K or 64K
Max 32 index columns
Index row max 40% of DB_BLOCK_SIZE

Microsoft SQL Server

CREATE [UNIQUE]
[CLUSTERED|NONCLUSTERED]
INDEX index_name
ON table (column1, column2...)
WITH FILLFACTOR = fillfactor

Leaf pages
= table

100 - PCTFREE

Pagesize 8K
Max 16 index columns
Max 900 data bytes