In the Db2 11.5 documentation, search for "Index design guidelines" and "CREATE INDEX statement." The administration guide covers index types (regular, expression-based, spatial, XML path), the INCLUDE clause, MDC, and index compression.