Hi, How can I use an index to search for null and non-null values? I have the following table (with one million rows):
CREATE TABLE tbl (id string primary key unique, time); CREATE INDEX time_ind on tbl(time); It seems that: select * from tbl where id notnull; does not use an index and takes a 'long' time. On the other hand select * from tbl where id > ''; returns immediately and uses an index. Are these two queries equivalent? Similarly, select * from tbl where id isnull; does not use an index and takes a 'long' time. Is there an indexed alternative? Thanks, Ron