Indexing NULL in the Oracle Database, is this the best practice?

  • From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 27 Dec 2016 10:24:28 -0400

Hello, please :)


CREATE INDEX emp_dob ON employees (date_of_birth, *'1'*)

http://use-the-index-luke.com/sql/where-clause/null/index

Other related posts: