text: Stay informed about any major changes. Click here to subscribe
  How to create an index
  Index enables faster sorting and searching through the data in a column.
  In principle, indexes are created for
  the columns that will be frequently searched. Indexes in databases are
  very similar to those in books. The database can find the data through
  indexes much faster, without having to search through each row in a table.
  A unique index is created in the primary
  key column of a table. According to the rules of database normalization,
  every table should have a column with unique values for marking and differentiating
  each row. This is done with the Primary Key. The columns in relationships
  between tables must also have a unique index.
  The video shows three tables without indexed ID columns. We will create
  indexes for them using the Indexes