I know this has been asked in the past, but sometimes things change over time and I wanted to check it again.
I have a table with about 9 billion lines. Should I add the index before or after inserting the data? I use Aurora. Is it important if I add more than one index?
All I know is that you should do this after insertion, but one of my colleagues insists that it is faster to do it on the insertion.