Indexes

Hello.

If I want to create a composite index on two columns, will Oracle Index a row if one
of the columns is optional? Meaning that one column has a value, the other is null???

I was told that Indexes are not created on rows with Null Values?

If this is true, then it would be better not to index that table, right???

I hope to hear something back????

Thanks.

Brad Worsfold Received on Tue Jul 22 1997 - 00:00:00 CDT