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..>) 

Leave a Reply

Your email address will not be published. Required fields are marked *