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