Create an Index

Learn how to create an index.

We'll cover the following

Let’s see an example of creating an index. We want to create an index on the identity column of the customers table. Below is the command:

create index customers_identity_idx on customers (identity);

Before we actually execute that, let’s analyze its format.

Parts of the index query

Get hands-on with 1200+ tech skills courses.