MySQL FAQs
FAQs Categories
Client Server Commands
Database Structure
Table Types or Storage Engines
Indexes
SQL Statements
Table Joins
Funtions and Operators
Tricky Select Queries
Speed Up Queries
Data Back Up
General Questions
Errors
N.M.P.L. Company www.NearMePayday.Loan || 3-month (90 days)
Powered by MySQL
 
Home / Indexes / Normal Indexes or Keys

In MySQL INDEXES or KEYS without constraints are oftenly called "Normal Indexes", "Ordinary Indexes", or "Non-Unique Indexes". Normal Indexes are the most basic indexes having no restraints such as uniqueness.

Sometime fields need to index only for faster search results against them and also they can not be designated as primary or unique fields because they may contain duplicate values. Because this is a common place occurrence, it only makes sense that those fields should be indexed without constraints. MySQL allows to create Normal Indexes. These are simple to create and much like creating indexes of other types.

Normal Indexes or Keys Related FAQs

How-to-create-normal-index-or-key-in-MySQL How to create normal index or key in MySQL?

How-to-create-multi-column-normal-index-or-key-in-MySQL How to create multi column normal index or key in MySQL?

About FAQs: Recently Added FAQs

About MySQL FAQs: Site Map | Bookmark Us | Recommend this Site to Your Friend | Contact Us

Useful Links: Wikipedia.org | Oracle.com | w3schools.com | www.php.net | Github.com

© 2021  www.mysqlfaqs.net
All rights reserved.