List all indices on an Andromeda table
listIndices(tbl)
An Andromeda
table (or any other 'DBI' table).
Returns a tibble listing the indices, indexed columns, and whether the index is unique.
Lists any indices that may have been created using the createIndex()
function.
andr <- andromeda(cars = cars)
createIndex(andr$cars, "speed")
listIndices(andr$cars)
#> # A tibble: 1 × 5
#> indexSequenceId indexName unique columnSequenceId columnName
#> <int> <chr> <lgl> <int> <chr>
#> 1 0 idx_k5p9bj6hrv0qeoxlfwya FALSE 0 speed
# # A tibble: 1 x 5
# indexSequenceId indexName unique columnSequenceId columnName
# <int> <chr> <lgl> <int> <chr>
#1 0 idx_ocy8we9j2i7ld0rshgb4 FALSE 0 speed
close(andr)