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