When executing UPDATE or DELETE operations on a table with low cardinality for certain column(s), the operations take a long time though the INSERT operations on those rows ran fast. There is an index on the column in question. The cardinality is a measure of the number of distinct column values as a percentage of all the column values. The higher the cardinality, the more the uniqueness in column value.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center