Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Securing and Maintaining a MySQL Database Indexing Columns in MySQL

Posted by Christopher Bijalba
Christopher Bijalba
12,446 Points

Indexing Columns in MySQL

I am only getting "Using where" under Extra, and not using the index... is this a problem?

Manav Misra
Manav Misra
11,778 Points

I too only got 'Using where' under Extra, but it looks like all other info was correct, most importantly, I think, the fact that it only searched over 2 rows, instead of 4.

1 Answer

Peter Do
Peter Do
12,294 Points
Peter Do
Peter Do
12,294 Points

In this database it isn't a problem because there are only 3 users. If this was a much larger database, you would want for it to use an index. Make sure when you create the new index that you type everything in correctly, and you get a green check box in the action screen. If it's indexed correctly, "Using index condition" should be listed under Extra in the results.