DB2: Indexes Cheat Sheet

Creating indexes

db2 create unique index <index_name> on 
<table_name>(<unique_column>) include (<column_names..>)

Dropping indexes

db2 drop unique index <index_name> on 
<table_name>(<unique_column>) include (<column_names..>)