Gerald, does N1QL treat deleted items like views do. For example in my above query, if a item is deleted does an index need to be updated so a deleted item will not show up in the result set? It would be great if N1QL did not have the issue around deleted items. Also going the other way does an index need to be updated before a result is shown in the results set? Much like the update_after on views.