Comments - Index Condition Pushdown
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
From chart,ICP could improve performance because "cut down the number of full record reads by checking whether index records satisfy part of the WHERE condition that can be checked for them";But example's second query's explain shows the same records it reads as first query--still 152064 rows;Since they read same number of rows,why example's second condition help improve performance?