These indices add data structures which allow ClickHouse to skip reading significant chunks of data that are guaranteed to have no matching values. More specifically, they create an index over blocks granules (effectively marks) allowing these to be skipped if the WHERE clause is not satisfied.
ITmedia�̓A�C�e�B���f�B�A�������Ђ̓o�^���W�ł��B，这一点在新收录的资料中也有详细论述
�@���C���̃v���[���g�ŁA�ł����ۂɎc���Ă����G�s�\�[�h���q�˂��B�u�����Ċ����ł��ꂽ�v�i20�㏗���A���Ј��j�A�u�e�Ƃ��������C�^���A���̂��X�ɍs���A�������������v�i20�㏗���A���Ј��j�A�u�����Ȃ��̂��Ȃ������̂������������v�i50���j���A���t�j�A�u�����S���Ȃ������̏Ί炪�Y�������Ȃ��v�i50�㏗���A���̑��j�Ƃ����������������B，更多细节参见新收录的资料
21│ 2022-10-24 00:00:00 │ 18 │。新收录的资料是该领域的重要参考