Best practices creating indexes

SQL++
2

Two things:

  1. Given a set of queries, you need to design the required indices. See the articles in DZone for guidance. N1QL Resources: Workshop, Articles and more
  2. Now that you’ve set of indices to handle all your queries, you need to have a HA strategy. Indexing talk here gives you some guidance: http://bit.ly/N1QL16
    Essentially, you need to have indices on all nodes. The query picks up from the available indices during optimization.
    (Index manageability is a feature we’re working on…).

@deepkaran.salooja, @jliang – please advice.