KB-32156: Using indexes and primary keys with Insert, Delete, and Update commands.

Question:

What is the effect of using indexes and primary keys in Insert, Delete, and Update commands?

Solution:

When using an index or a primary key in the Insert command, its execution gets slower. However, the Delete and Update commands’ execution become faster when they have a Query clause.

We also recommend that you use indexes to improve the Queries’ performance.

Print Friendly, PDF & Email

Este artigo foi útil? Was this helpful?

Classificação média - Average rating 0 / 5. Count: 0

Leave a Reply

Your email address will not be published.Required fields are marked *