Published on InterSystems Developer Community (https://community.intersystems.com)

Home > Custom Index for Not Null Values Only

Question
Uri Shmueli · Aug 10, 2017

Custom Index for Not Null Values Only

Hi

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é

Source URL:https://community.intersystems.com/post/custom-index-not-null-values-only