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>:
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-lReceived on Fri Apr 11 2014 - 08:09:50 CEST