Conditions in indexes

SQL++
1

Hi,

I was looking into indexes and can’t get an answer why and when to use WHERE condition in CREATE INDEX queries?
When can I benefit from it?

Thanks

2

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.

See N1QL Resources: Workshop, Articles and more

1 Like
3

Please see the following:


2 Likes