вторник, 5 апреля 2016 г.

Which of SELECT, UPDATE, DELETE, performance is mostly affected by indexes?

I have found answer on this blog:

The number of indexes on a table is the most dominant factor for insert
performance. The more indexes a table has, the slower the execution becomes. The insert statement is the only operation that cannot directly benefit from indexing because it has no where clause.


Комментариев нет:

Отправить комментарий