List all indices on an Andromeda table

listIndices(tbl)

Arguments

tbl

An Andromeda table (or any other 'DBI' table).

Value

Returns a tibble listing the indices, indexed columns, and whether the index is unique.

Details

Lists any indices that may have been created using the createIndex() function.

Examples

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)