how many indexes are too many indexes or as long as the columns are used in the query it is not a problem?
PK
Povilas Korop
✓ Link copied!
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.
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