Couchbase indexes performance

I’m trying to find the best way to use indexes/views to get better performance for my queries and I have some questions about this:

  • Where are GSI/views stored and what are the informations being persisted (only documents keys or key/value ?)

  • Another important thinh, from what I have understand, indexes are organized as b-tree.
    In RDMS, when creating an index, the b-tree construction is based on the column type (numeric, date…), but for couchbase, how is the b-tree build without knowing the type of field being indexed.

I would suggest you try it out, measure the speedup, and then worry about the internals.

Lots of material here: N1QL Resources: Workshop, Articles and more