Example TablesExisting IndexesSingle Column IndexesSyntaxRestricting Rows with an Index Joining Tables with an IndexUnderstanding Index CardinalityUsing Indexes for Pattern MatchingSelecting a Unique RowOrdering ResultsMulti Column IndexesDetermining Which Index to UseMulti Column Index SyntaxProviding a Better IndexMany Column IndexesCombining WHERE and ORDER BYMySQL Optimizer FeaturesQuery HintsComplicated QueriesThe Impact of Adding IndexesDML ImpactDDL ImpactDisk Space ImpactMySQL LimitationsCost Based OptimizerQEP PinningIndex StatisticsFunction Based IndexesMultiple Indexes per TableConclusion