MAmacrometa
Indexes

Create skip list

Create a hash index.

Note:

  • In a sparse index all documents are excluded from the index that do not contain at least one of the specified index attributes (i.e. fields) or that have a value of null in any of the specified index attributes. Such documents are not indexed and are not taken into account for uniqueness checks if the unique flag is set.
  • In a non-sparse index, these documents are indexed (for non-present indexed attributes, a value of null is used) and are taken into account for uniqueness checks if the unique flag is set.
  • Unique indexes on non-shard keys are not supported in a cluster.
post/_fabric/{fabric}/_api/index/skiplist

Request

Path parameters

fabricstring string required

The name of the fabric.

Query parameters

collectionstring required

The collection name.

Request body

deduplicateboolean

If false, the deduplication of array values is turned off.

fieldsstring[]

An array of attribute paths.

sparseboolean

True to create a sparse index.

typestring required

Must be equal to "skiplist".

uniqueboolean

True to create a unique index.

Example request

{
  "fields": [
    "_key"
  ],
  "sparse": true,
  "type": "skiplist",
  "unique": true
}

Response

Successfully fetched existing skiplist index.

codeinteger

HTTP response code.

errorboolean

Flag if there is an error in response. False for this response.

fieldsstring[]

HTTP response code.

idstring

Index identifier.

namestring

Name of the index.

selectivityEstimatenumber

The selectivity estimate of index.

sparseboolean

True if index is sparse type.

typestring

Index type.

uniqueboolean

True if index is unique.

Example response

{
  "code": 200,
  "fields": [
    "_key"
  ],
  "id": "61862387",
  "name": "idx_1723573111790501888",
  "selectivityEstimate": 1,
  "type": "skiplist",
  "unique": true
}

Changes

No recorded changes to this operation across all 1 revision of this API.