I'm not sure how to answer this from the documentation, and am unable to find an answer through searching.
I'm wondering: if there's an existing table which is being updated (having data added to it), could I lose any of the data by adding an index to the table?
I don't mind things slowing down a bit, but I don't want to lose data as a result of adding an index, due to the table being locked or something whilst the index is being created.
To be clear, there is an existing table within a database, data is being added to the table, and I would like to add an index to the table. I am unsure if I could lose some of the data being added to the table whilst the index is being made or something.