I have this query to find nearest points from an array of points (geo search using “bounding box” concept): SELECT d.type, d.name, d.`key`, p.*, (ACOS(SIN( RADIANS(55.55)) * SIN(RADIANS(p.lat)) + COS( RADIANS(55.55 )) * COS(RADIANS(p.lat)) * COS(RADIANS(p.lon) - RADIANS(…

Try this. Query should cover with index. You need to use [p.lat, p.lon] as pair, include array index key as leading key CREATE INDEX `ix1` ON `data`((all (array [(`p`.`lat`), (`p`.`lon`)] for `p` in `points` end)), `type`,`name`,`key`) WHERE (`type` in ["Lake", "Stream", "PutTakeLake", "CoastLocalA…

Appropriate index for query with unnest

SQL++

jda June 4, 2021, 3:00pm 7

Great, then I think I understand it! But good to have a heads up

Topic		Replies	Views
How to index this location query? SQL++ query , n1ql	7	2175	October 3, 2016
How do I create an index to cope with UNNEST'ed queries? SQL++ n1ql	10	1490	August 8, 2018
Access to index without SQL++ query SQL++ query , n1ql	59	330	August 17, 2025
Array Covering index with UNNEST and condition SQL++ n1ql , index	30	4064	April 16, 2018
Problems getting unnest query to use nested array index SQL++ index	6	1921	January 6, 2019

Appropriate index for query with unnest

Related topics