Technical task
Major Description
build: 6.5.0-3415
standard `travel-sample` bucket
run the following:
ADVISE SELECT DISTINCT airline.name
|
FROM `travel-sample` airport
|
INNER JOIN `travel-sample` route ON airport.faa = route.sourceairport
|
AND route.type = "route" |
INNER JOIN `travel-sample` airline ON route.airline = airline.iata
|
AND airline.type = "airline" |
WHERE airport.type = "airport" |
AND airport.city = "San Jose" |
AND airport.country = "United States" |
You will find duplicate items in current_indexes section
"current_indexes": [ |
{
|
"index_statement": "CREATE INDEX def_type ON `travel-sample`(`type`)" |
},
|
{
|
"index_statement": "CREATE INDEX def_city ON `travel-sample`(`city`)" |
},
|
{
|
"index_statement": "CREATE INDEX def_faa ON `travel-sample`(`faa`)" |
},
|
{
|
"index_statement": "CREATE INDEX def_sourceairport ON `travel-sample`(`sourceairport`)" |
},
|
{
|
"index_statement": "CREATE INDEX def_route_src_dst_day ON `travel-sample`(`sourceairport`,`destinationairport`,(distinct (array (`v`.`day`) for `v` in `schedule` end))) WHERE (`type` = 'route')" |
},
|
{
|
"index_statement": "CREATE INDEX def_type ON `travel-sample`(`type`)" |
},
|
{
|
"index_statement": "CREATE INDEX def_type ON `travel-sample`(`type`)" |
}
|
]
|
Last 2 entries.