Indexes are the database objects created based on one or more columns of a table. Indexes are used to improve the query performance and guarantee uniqueness when defined as unique indexes. In this section, you will learn how to work with indexes in Db2 so that you can leverage indexes to make your queries faster and more efficient.
- CREATE INDEX – show you how to create a new index.
- DROP INDEX – describe how to delete an index from the database.
- UNIQUE index – ensure the uniqueness of values stored in one or more columns.
- Expression-based index – allow you to create index expressions instead of just columns.