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

Learn section

modules/learn/examples/services-and-indexes/indexes/pushdown-def-city.n1ql:
  1: CREATE INDEX def_city ON `travel-sample`(city ASC);

modules/learn/pages/clusters-and-availability/xdcr-filtering-expressions.adoc:
   24: Note that most examples assume the `travel-sample` bucket to be the source of the filtered replication.
   45: If `travel-sample` is used as the source bucket, every document that contains a field `country` whose value is `"France"` is replicated to the target.
   72: This would match a number of documents from `travel-sample`, including `airline_10`, whose metadata is as follows:
  135: Lookahead might therefore be used on the `travel-sample` bucket, to filter documents whose metadata _id_ contains `airport` rather than `airline`, or vice versa.

modules/learn/pages/services-and-indexes/indexes/index_pushdowns.adoc:
   36: ON `travel-sample`(`sourceairport`,`destinationairport`,
   44: EXPLAIN SELECT sourceairport FROM `travel-sample`
  153: ON `travel-sample`(`distance`,`sourceairport`,`destinationairport`)
  161: FROM `travel-sample`
  214: FROM `travel-sample`
  270: EXPLAIN SELECT * FROM `travel-sample`
  295: CREATE PRIMARY INDEX `def_primary` ON `travel-sample`;
  301: EXPLAIN SELECT * FROM `travel-sample`
  330: EXPLAIN SELECT * FROM `travel-sample`
  372: EXPLAIN SELECT city FROM `travel-sample`
  405: EXPLAIN SELECT city FROM `travel-sample`
  441: CREATE INDEX def_city_desc ON `travel-sample`(`city` DESC);
  447: EXPLAIN SELECT city FROM `travel-sample`
  476: Find the alphabetically highest city name in `travel-sample`.
  489: FROM `travel-sample`
  511: Find the alphabetically lowest city name in `travel-sample`.
  524: FROM `travel-sample`
  544: Find the number of cities entered in `travel-sample`.
  557: FROM `travel-sample`
  582: FROM `travel-sample`
  604: Find the number of unique city names in `travel-sample`.
  617: FROM `travel-sample`
  642: FROM `travel-sample`

modules/learn/pages/services-and-indexes/indexes/index-scans.adoc:
    58: To run the examples, xref:manage:manage-settings/install-sample-buckets.adoc[install the `travel-sample` sample bucket] and create these indexes:
    62: CREATE INDEX idx_id ON `travel-sample`(`id`);
    64: CREATE INDEX idx_name ON `travel-sample`(`name`);
    66: CREATE INDEX idx_s_d_airport_stops ON `travel-sample`(`sourceairport`, `destinationairport`, `stops`);
    68: CREATE INDEX idx_sched ON `travel-sample`(DISTINCT ARRAY v.day FOR v IN schedule END) WHERE type = "route";
    98: EXPLAIN select meta().id from `travel-sample` where id = 10;
   113:             "cover ((`travel-sample`.`id`))",
   114:             "cover ((meta(`travel-sample`).`id`))"
   118:           "keyspace": "travel-sample",
   143:                 "condition": "(cover ((`travel-sample`.`id`)) = 10)"
   149:                     "expr": "cover ((meta(`travel-sample`).`id`))"
   161:     "text": "select meta().id from `travel-sample` where id = 10;"
   203: SELECT meta().id FROM `travel-sample` WHERE id = 10;
   220: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id = 10;
   246: SELECT meta().id FROM `travel-sample` WHERE id >= 10;
   263: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id >= 10;
   288: SELECT meta().id FROM `travel-sample` WHERE id > 10;
   305: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id > 10;
   330: SELECT meta().id FROM `travel-sample` WHERE id <= 10;
   348: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id <= 10;
   374: SELECT meta().id FROM `travel-sample` WHERE id < 10;
   392: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id < 10;
   418: SELECT meta().id FROM `travel-sample` WHERE id >= 10 AND id < 25;
   435: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id >=10 AND id < 25;
   461: SELECT meta().id FROM `travel-sample` WHERE id >= 10 AND id < 25 AND id <= 20;
   478: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id >=10 AND id < 25 AND id <= 20;
   546: SELECT meta().id FROM `travel-sample` WHERE id > 10 AND id < 5;
   566: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id > 10 AND id < 5;
   592: SELECT meta().id FROM `travel-sample` WHERE id BETWEEN 10 AND 25;
   609: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id BETWEEN 10 AND 25;
   635: SELECT meta().id FROM `travel-sample` WHERE id = 10 OR id = 20;
   658: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id = 10 OR id = 20;
   694: SELECT meta().id FROM `travel-sample` WHERE id IN [10, 20];
   720: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id IN [10, 20];
   756: SELECT meta().id FROM `travel-sample` WHERE (id BETWEEN 10 AND 25) OR (id > 50 AND id <= 60);
   778: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE (id BETWEEN 10 AND 25) OR (id > 50 AND id <= 60);
   814: SELECT meta().id FROM `travel-sample` WHERE id <> 10;
   836: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id <> 10;
   871: SELECT meta().id FROM `travel-sample` WHERE NOT (id >= 10 AND id < 25);
   893: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE NOT (id >= 10 AND id < 25);
   928: SELECT meta().id FROM `travel-sample` WHERE name = "American Airlines";
   945: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE name = "American Airlines";
   971: SELECT meta().id FROM `travel-sample` WHERE name >= "American Airlines" AND name <= "United Airlines";
   988: EXPLAIN SELECT meta().id FROM `travel-sample`
  1016: SELECT meta().id FROM `travel-sample` WHERE name LIKE "American%";
  1034: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE name LIKE "American%";
  1060: SELECT meta().id FROM `travel-sample` WHERE name LIKE "%American%";
  1080: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE name LIKE "%American%";
  1105: SELECT meta().id FROM `travel-sample`
  1135: EXPLAIN SELECT meta().id FROM `travel-sample`
  1174: SELECT meta().id from `travel-sample`
  1210: EXPLAIN SELECT meta().id FROM `travel-sample`
  1269: SELECT meta().id FROM `travel-sample` WHERE sourceairport = "SFO" AND destinationairport = "JFK";
  1291: EXPLAIN SELECT meta().id FROM `travel-sample`
  1324: SELECT meta().id FROM `travel-sample`
  1354: EXPLAIN SELECT meta().id FROM `travel-sample`
  1392: SELECT meta().id FROM `travel-sample` WHERE id = $1;
  1409: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id = $1;
  1435: SELECT meta().id FROM `travel-sample` WHERE id >= $1 AND id < $2;
  1452: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id >= $1 AND id < $2;
  1478: SELECT meta().id FROM `travel-sample` WHERE id = $1 OR id < $2;
  1500: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id = $1 OR id < $2;
  1536: SELECT meta().id FROM `travel-sample` WHERE id IN [ $1, 10, $2] ;
  1565: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id IN [$1, 10, $2];
  1609: SELECT meta().id FROM `travel-sample`
  1629: EXPLAIN SELECT meta().id FROM `travel-sample`
  1658: SELECT meta().id FROM `travel-sample`
  1690: EXPLAIN SELECT meta().id FROM `travel-sample`
  1741: SELECT meta().id FROM `travel-sample` WHERE abs(id) = 10;
  1758: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE abs(id) = 10;
  1783: CREATE INDEX `idx_absid` ON `travel-sample`(abs(`id`));
  1800: EXPLAIN SELECT meta().id FROM `travel-sample` USE INDEX (idx_absid) WHERE abs(id) = 10;
  1826: SELECT meta().id FROM `travel-sample` WHERE id <= 100 OR (id BETWEEN 50 AND 150);
  1848: EXPLAIN SELECT meta().id FROM `travel-sample` WHERE id <= 100 OR (id BETWEEN 50 AND 150);