Treehouse | Community | Indexing Columns in MySQL

🤑 Join the Treehouse affiliate program and earn 25% commission!

🌟 Dreaming of a bright future? 🎓 Ask about the Treehouse Scholarship program! 🚀

Curious which AI tools Treehouse developers love? ⚙️ Check them out!

🫡 Treehouse for Military offers discounts to Veterans, service members and their families!

Newest
- Newest
- Active
- Unanswered
- Featured
All Topics

T K
21,479 Points
Just to clarify my understanding of Database Indexing...

Posted April 18, 2016 7:52pm by T K

T K
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.