Description
Assume that the schema for a data and index table is as follows:
create table datatable (id varchar(10) not null primary key, val1 varchar(10), val2 varchar(10), val3 varchar(10))
create index indextable on datatable (val1) include (val2, val3)
A query that filters rows on a covered column does not trigger the index read repair for unverified index rows. For example, the following query will not trigger the read repair
select val2, val3 from datatable WHERE val1 = 'ab' and val2 = 'abc'
Attachments
Attachments
Issue Links
- links to