In DB2, performance affects on the size of the index. When you create an index, it is useful to exclude one or more values from being indexed – such as values that will never be used in a SQL query. For example NULL, blank, and 0. RelatedDB2 V11 New Functions: Read Right Away Improvement in … Continue reading DB2 INSERT’s Performance and What is Newly Added