Your indexes will be smaller and more efficient if they only index the subset of documents you are potentially querying. @prasad and @keshav_m can point you to dzone articles about this.
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Best practice on n1ql index? | 3 | 2124 | January 6, 2016 | |
| Basic principles/Best practice for CREATE INDEX in N1QL | 2 | 1724 | May 15, 2016 | |
| N1QL: docs update and articles | 2 | 1572 | September 11, 2016 | |
| Partial index creation (where condition) in Couchbase Java SDK 3.0 | 3 | 1648 | August 24, 2021 | |
| N1QL Covering Indexes / Performance for Sorting and Where Conditions | 9 | 2633 | September 16, 2016 |