Go NULL values into an index?

Hi Board Members!
 Maybe a often posed question,
 but I dare to ask you directly:

 If there is a not null column named 'c1' and  this column is part of an index

• eg.: create (unique) index idx1 on t1(c1,c2...) - will the null values "go" into the index, so that a select * from t1 where c1 is null; or any other select statement can make use of the index ? Thanks in advance!

 Andreas Received on Mon Jan 08 2001 - 21:52:16 CST