5 ms·
It depends on how much data you have in the table you're adding the index to and how much traffic you're dealing with. I deal with this every day (SQL 2017) and
by mastry 7y ago
It depends on how much data you have in the table you're adding the index to and how much traffic you're dealing with. I deal with this every day (SQL 2017) and I assure you that adding an index to a large table has noticeable overhead in a heavily used system.
- bartread 7y agoFor sure, but my beef here (as every time I hear this) is that it's taking an exception and turning it into a fear-mongering boogie-man story that paralyses people into inaction when they (often) have serious performance bottlenecks in their database that need to be addressed. So often with performance it's down to the basics not being followed, and often this comes down to the lack of an appropriate index.