For the boolean column Foo in Table1, if I want to index all values of
TRUE, is this syntax correct?
CREATE INDEX IDX_MyIndex ON Table1(Foo) WHERE Foo;
The query:
SELECT * FROM Table1 WHERE Foo;
should use the index, and:
SELECT * FROM Table1 WHERE NOT Foo;
should not, correct?
I just want to make sure I don't need an operator on the WHERE clause. Thanks!
Mike