# Query: travel-sample
# Flags: WordMatch RegExp
# Including: ./docs-server
# Excluding: *.html,*.json

N1QL cost-based optimizer pages

modules/n1ql/pages/n1ql-language-reference/statistics-delete.adoc:
  138: UPDATE STATISTICS FOR `travel-sample` DELETE (type, city, country);
  147: ANALYZE KEYSPACE `travel-sample` DELETE STATISTICS (type, city, country);
  158: UPDATE STATISTICS FOR `travel-sample` DELETE ALL;
  167: ANALYZE KEYSPACE `travel-sample` DELETE STATISTICS;

modules/n1ql/pages/n1ql-language-reference/statistics-expressions.adoc:
  139: CREATE INDEX idx_country_city ON `travel-sample`(country, city);
  140: CREATE INDEX idx_city_country ON `travel-sample`(city, country);
  146: UPDATE STATISTICS FOR `travel-sample`(type, city, country);
  152: EXPLAIN SELECT COUNT(*) FROM `travel-sample` WHERE country = 'France';
  168:             "cover ((`travel-sample`.`country`))",
  169:             "cover ((`travel-sample`.`city`))",
  170:             "cover ((meta(`travel-sample`).`id`))",
  190:           "keyspace": "travel-sample",
  227:     "text": "SELECT count(*) FROM `travel-sample` WHERE country = 'France';"
  244: UPDATE STATISTICS FOR `travel-sample`(type, city, country, free_breakfast);
  253: EXPLAIN SELECT COUNT(*) FROM `travel-sample` WHERE country = 'United States' AND type = 'hotel' AND free_breakfast = true;
  273:           "keyspace": "travel-sample",
  293:           "keyspace": "travel-sample",
  304:                 "condition": "((((`travel-sample`.`country`) = \"United States\") and ((`travel-sample`.`type`) = \"hotel\")) and ((`travel-sample`.`free_breakfast`) = true))",
  352:     "text": "SELECT COUNT(*) FROM `travel-sample` WHERE country = 'United States' AND type = 'hotel' AND free_breakfast = true;"
  368: CREATE INDEX idx_public_likes ON `travel-sample`((DISTINCT (`public_likes`)));
  374: UPDATE STATISTICS FOR `travel-sample`((DISTINCT (`public_likes`)));
  381: FROM `travel-sample`
  402:               "cover ((distinct ((`travel-sample`.`public_likes`))))",
  403:               "cover ((meta(`travel-sample`).`id`))"
  406:               "cover (any `p` in (`travel-sample`.`public_likes`) satisfies ((\"A\" \u003c= `p`) and (`p` \u003c \"B\")) end)": true,
  407:               "cover (any `p` in (`travel-sample`.`public_likes`) satisfies (`p` like \"A%\") end)": true
  421:                 "condition": "cover (any `p` in (`travel-sample`.`public_likes`) satisfies (`p` like \"A%\") end)",
  437:     "text": "SELECT COUNT(1)\nFROM `travel-sample`\nWHERE ANY p IN public_likes SATISFIES p LIKE 'A%' END"
  449: CREATE INDEX idx_reviews_ratings_overall ON `travel-sample`(DISTINCT ARRAY r.ratings.Overall FOR r IN reviews END);
  455: UPDATE STATISTICS FOR `travel-sample`(DISTINCT ARRAY r.ratings.Overall FOR r IN reviews END);
  462: FROM `travel-sample`
  479:             "cover ((distinct (array ((`r`.`ratings`).`Overall`) for `r` in (`travel-sample`.`reviews`) end)))",
  480:             "cover ((meta(`travel-sample`).`id`))",
  484:             "cover (any `r` in (`travel-sample`.`reviews`) satisfies (((`r`.`ratings`).`Overall`) = 4) end)": true
  492:     "text": "SELECT COUNT(1)\nFROM `travel-sample` WHERE ANY r IN reviews SATISFIES r.ratings.Overall = 4 END"

modules/n1ql/pages/n1ql-language-reference/statistics-index.adoc:
  175: UPDATE STATISTICS FOR INDEX `travel-sample`.def_city;
  184: UPDATE STATISTICS FOR INDEX def_city ON `travel-sample`;
  195: ANALYZE INDEX `travel-sample`.def_city;
  206: ANALYZE INDEX def_city ON `travel-sample`;

modules/n1ql/pages/n1ql-language-reference/statistics-indexes.adoc:
  163: UPDATE STATISTICS FOR `travel-sample` INDEX (def_faa, def_icao);
  172: ANALYZE KEYSPACE `travel-sample` INDEX (def_faa, def_icao);
  183: UPDATE STATISTICS FOR `travel-sample` INDEX (( -- <1>
  188:     AND keyspace_id = "travel-sample" ));
  203: ANALYZE KEYSPACE `travel-sample`.modes.train INDEX ((
  208:     AND bucket_id = "travel-sample"