Want to access all of our courses? (36 h 00 min)
You also get:
Already a member? Login here
how many indexes are too many indexes or as long as the columns are used in the query it is not a problem?
There's no one right answer here. With every index, the SIZE of your database table grows bigger, so it may slow down the whole MySQL engine with too many columns. You need to test it out yourself.
Thank you
Tell us what you like or what we can improve
Feel free to share anything you like or dislike about this page or the platform in general.
Your feedback has been received. We truly appreciate you taking the time to help us improve.
how many indexes are too many indexes or as long as the columns are used in the query it is not a problem?
There's no one right answer here. With every index, the SIZE of your database table grows bigger, so it may slow down the whole MySQL engine with too many columns. You need to test it out yourself.
Thank you