Treehouse | Community | Indexing Columns in MySQL

Don't forget to gift yourself this Cyber Monday 👀 Get a year of Courses for $150 (40% off!)

Dive into new course Game Development with Phaser 👾

New AI course: Introduction to Computer Vision 💻

💥 ALL NEW: Code Adventures! ⚡ Dare to embark on a front end coding adventure 🌟

Get job-ready with our Career Toolbox Track's career advice, resume tips, and more 🧰

🤖 Check out all our AI content here 👀

Learn about our new Community Discord server here and join us on Discord here!

Students: got a cool project or resource to share? Submit it to Treehouse Links! 🤩

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

Tayler Kemsley
21,479 Points
Just to clarify my understanding of Database Indexing...

Posted April 18, 2016 7:52pm by Tayler Kemsley

Tayler Kemsley
21,479 Points
1 Answer
Cecilie Johnsen
1,694 Points
Single or double quotes in MySQL

Posted December 6, 2015 2:29pm by Cecilie Johnsen

Cecilie Johnsen
1,694 Points
1 Answer
Pavle Lucic
10,801 Points
CHALLENGE 2/2 not passing

Posted July 10, 2015 5:12pm by Pavle Lucic

Pavle Lucic
10,801 Points
1 Answer
Leigh Maher
21,830 Points
Difficulty grasping the Index concept

Posted June 29, 2015 12:32pm by Leigh Maher

Leigh Maher
21,830 Points
7 Answers
Warren Bennett
532 Points
can you reference a column using the "." syntax? ie does users.first_name =users(first_name)?

Posted April 10, 2015 8:29pm by Warren Bennett

Warren Bennett
532 Points
1 Answer
Christopher Bijalba
12,446 Points
Indexing Columns in MySQL

Posted September 26, 2014 11:14pm by Christopher Bijalba

Christopher Bijalba
12,446 Points
1 Answer
Don Shipley
19,488 Points
Challenge task 2 of 2 Use the EXPLAIN keyword to explain a where query where you see if the 'first_name' equals 'Pasan'

Posted July 25, 2014 3:12pm by Don Shipley

Don Shipley
19,488 Points
1 Answer
Kyle Robertson
31,600 Points
MySQL EXPLAIN statement still says "Using where" in the Extra column after creating an index.

Posted May 20, 2014 3:36am by Kyle Robertson

Kyle Robertson
31,600 Points
3 Answers

Posting to the forum is only allowed for members with active accounts.
Please sign in or sign up to post.