Questions tagged [couchbase-indexing]
4 questions
1
vote
1 answer
What data is stored inside of a Couchbase Index?
Situation
I'm working w/ a Couchbase database that keeps running into OOM issues, a lot of the time it's with the Index Service running out of memory. When I fire up the Couchbase dashboard to get more info I can see that index foobar has X amount…
Scott Sword
- 4,648
- 6
- 32
- 37
1
vote
0 answers
N1QL query works even with missing predicate created using couchbase secondary index
I have created a secondary index in couchbase:
CREATE INDEX `data` ON `bucket`(`field1`,`field2`,`field3`,
lower(`field4`)) WHERE (`field5` = "CONSTANT")
When I execute this query on couchbase:
select document.* from bucket AS document WHERE…
Madhumitha
- 11
- 1
1
vote
1 answer
Will there be a performance overhead when using an index having Object_Pairs (in case of a covered query) - Couchbase
Suppose I create an index on Object_pair(values).val.data.
Will my index store the “values” field as an array (with elements name for ID and val for data due to object_pair)?
If so, and also if my n1ql query is a covered query (fetching only…
anshul.gairola
- 31
- 2
1
vote
1 answer
Couchbase analytics: create index compilation error
I'm trying to create an index on a couchbase analytics node:
CREATE INDEX `index_analytics_user_id`
ON `requests`(userId:string)
When I run this on a couchbase I have running locally it works fine. However when I run it on the larger scale…
robjwilkins
- 5,462
- 5
- 43
- 59