I apologize if I am missing something elementary here. I cannot understand
why this index is not helpful.
CREATE TABLE [T1](
[C1] TEXT,
[C2] TEXT,
[C3] DATE);
CREATE INDEX [IndxT1C3]
ON [T1](
[C3] COLLATE [NOCASE]);
insert into t1 values
('aa','bb','2016-01-01'),
('ab','bb','2016-01-02'),
('ac','bc','2016-01-03');
analyze;
----------
after doing this:
explain query plan
select C1 from T1
where C3='2016-01-02'
----> 0, 0, 0,0 SCAN TABLE T1
and
explain query plan
select C1 from T1 indexed by IndxT1C3
where C3='2016-01-02'
----> no query solution
Why can this index not be used?
Thank you,
Denis Burke
