"indexProviders" : {
        "local" : {
            "classname" : "org.modeshape.jcr.index.local.LocalIndexProvider",
            "directory" : "index",
            "cacheLRUEnable" : true,
            "mmapFileEnable" : true,
            "commitFileSyncDisable" : false
        }
    },
    "indexes" : {
        "editorsByIsActive" : {
            "kind" : "value",
            "provider" : "local",
            "nodeType" : "hes:editor",
            "columns" : "isActive( BOOLEAN )"
        }
  }

Create node1 with mixin: hes:editor and with an attribute isActive = true
Create node2 with mixin: hes:editor and with an attribute isActive = true
Run the following queries
select * from [hes:editor] where isActive=true - return 2 nodes
select * from [hes:editor] - return: 2 nodes
Update node2 setting isActive=false
Run again the same queries
select * from [hes:editor] where isActive=true - return 0 nodes
select * from [hes:editor] - return: 2 nodes
Reindex (calling reindex API)
Run again the same queries
select * from [hes:editor] where isActive=true - return 1 node
select * from [hes:editor] - return: 2 nodes