Index options
Optional
Index name
Index type: BTREE, HASH, GIN, GiST, BRIN, etc.
Unique index
Index if not exists
Partial index WHERE clause
NULLS FIRST/LAST (PostgreSQL)
Index options