Custom Index for Not Null Values Only

Question

Uri Shmueli · Aug 10, 2017

1. Is it possible do define an index like that :

create index UIX on MyTable (Column1) where Column1 is not null

2. What happens if we add an index on a property that is NOT required, meanning that not all records will be indexed because we do not allow null subscripts ?

#Indexing #Object Data Model #Caché