We have a table with a lot of insert\select
every time ( like 100 machines inserting\updating every second).
What is the best way to create an index on a table that can't be locked not even for a second?
If I create the index, i'm sure it will lock the requests, and I can't do it.
It's a big table with 1 million rows+.