Impact with the use of INDEXES in MySQL

0

I have a table that currently has 25 million records , so any query I make, however simple, becomes very slow.

I was researching on INDICES to improve search performance and found that it helps a lot on speed issues and that's great, but I've seen a lot of comments talking about the negative impact they can have on inserts and changes (slow down).

This table I want to modify (create indices) suffers many insertions and sometimes with more than 100 thousand records at a time.

My question is this, does this impact on insertion or change after creating an index actually happen? I'm afraid to fine-tune the question of queries, however, upsetting other things

    
asked by anonymous 03.05.2018 / 17:52

0 answers