Re: Column with NULLs, how would it impact an index

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Fri, 11 Apr 2014 09:09:50 +0300
Message-ID: <CAN2wOq2e96Yo40uWp31LRypk2DY+XQR=G1PzdRE_+AbXrSOVSA_at_mail.gmail.com>

2014-04-10 22:42 GMT+03:00 Nik Tek <niktek2005_at_gmail.com>:

> >Can anyone send me some pointers on it, to read about indexes on null
columns.
Richard Foote's oracle blog has plenty of info about indexes For indexing null values for example :
http://richardfoote.wordpress.com/2008/01/23/indexing-nulls-empty-spaces/ http://richardfoote.wordpress.com/2008/01/30/how-are-nulls-actually-indexed-fascination/

and many more

Gints

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Apr 11 2014 - 08:09:50 CEST

This message: [ Message body ]
Next message: Fred Habash: "Relocating Flashback Recovery Area While A Guranteed Restore Point Is Present"
Previous message: Chitale, Hemant K: "RE: Column with NULLs, how would it impact an index"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message