If you define an index on a column or columns, the query optimizer can
use the index to find data in the column more quickly. automatically
creates indexes to back up primary key, foreign key, and unique constraints,
so those indexes are always available to the optimizer, as well as those that
you explicitly create with the CREATE INDEX command. The way gets
to the data-via an index or directly via the table-is called the access path.