indexing - Do mysql update queries benefit from an index? -


i have table updates , i'm wondering if update queries benefit having index on column , updated column or index on column?

just on column. index on update column slow down query because index has updated along data. index on column speed updates, , selects, slow down insertions.

indices cause overhead when delete rows. in general thing though on columns using where on lot, , necessary on columns joins on, or order by


Comments

Popular posts from this blog

javascript - Iterate over array and calculate average values of array-parts -

iphone - Using nested NSDictionary with Picker -

objective c - Newbie question -multiple parameters -