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:
- » Indexing NULL in the Oracle Database, is this the best practice? - Juan Carlos Reyes Pacheco
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Mark W. Farnham
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Mladen Gogala
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Reen, Elizabeth
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Sayan Malakshinov
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Luis Santos
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Reen, Elizabeth
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Mladen Gogala
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Sayan Malakshinov
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Sayan Malakshinov
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Reen, Elizabeth
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Michael D O'Shea/Woodward Informatics Ltd
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Mladen Gogala
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Reen, Elizabeth
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Michael D O'Shea/Woodward Informatics Ltd
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Lothar Flatz
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Mladen Gogala
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Mladen Gogala
- » Re: Indexing NULL in the Oracle Database, is this the best practice?- Michael D O'Shea/Woodward Informatics Ltd
- » RE: Indexing NULL in the Oracle Database, is this the best practice?- Reen, Elizabeth