why arent all nulls allowed in a b-tree index?
if we were to store all the nulls at the beginning (and put the rowid of the index in there as well so each entry remains unique), and say we put all the null entries in the left-most blocks of the index, then we could easily search for all nulls in the table. Why doesn't Oracle allow this?
thanks