Tips, Tricks and Tools
... and Thoughts
(Move to ...)
Home
All Posts
Firefox Extensions
JavaScript Compiler and Encoder
Bulk Player for YouTube
Misc Tools
Support
▼
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.
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment