Indexes

Indexes

by Bryce Oveson -
Number of replies: 0

Indexing is the process of compiling an index. In computer science we use indexing for our rows to make each row have a specific value. Indexes are used to find rows with the specific value quickly instead of having to go through each row to find the value. We represent these indexes when we are creating a table with the column names using ‘PRIMARY KEY’, ‘UNIQUE INDEX’, and ‘FULLTEXT’. Often the “go-to” for indexes are numbering each row with PRIMARY KEY. More ways to use indexes can be found on the mysql site here: https://dev.mysql.com/doc/refman/8.0/en/mysql-indexes.html