CASE used in CREATE INDEX
Friday, July 8th, 2005
The following is a neat way to index id1,id2 when id is not null, and index NULL,NULL (which won’t be indexed) when it is:
News, views, tips and tricks on Oracle and other fun stuff
The following is a neat way to index id1,id2 when id is not null, and index NULL,NULL (which won’t be indexed) when it is:
