Friday, November 22, 2019
Oracle: create index for column that allows NULL
CREATE INDEX table1_nullable_col1_idx
ON table1 (nullable_col1, 1);
The ", 1" makes Oracle add into the index the record whose nullable_col1 field has a NULL value.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment