Andy Fan <zhihuifan1...@163.com> writes: > (3). DELETE does generate new index entry, but we might not touch > the indexes at all during deletes (*except the index we used for index > scan*).
I still not check the code right now (it may still take times for me even I understand the overall design). So do we need to mark the "garbage" hints for DELETE with a index scan? The case in my mind is: CREATE TABLE t(a INT, B int); CREATE INDEX t_a_idx on t(a); CREATE INDEX t_b_idx on t(b); DELETE FROM t WHERE b = 1; If the delete goes with Index Scan of t_b_idx, we still have the chances to mark hints on t_b_idx, so that it can be useful during index split? -- Best Regards Andy Fan
