Indexes with NULL values
445540Dec 31 2005 — edited Sep 13 2007Hello.
I am developing an application for my company. The application was implemented in Microsoft Access and I need to use a specific type of Access index that ignores rows where any of the indexed columns are null. For Oracle each of these rows are included in the index while Access simply ignores them.
Is there any way to tell Oracle to ignore such rows....... I mean: Avoid indexing a row where any of the indexed columns are null.
thanks