Feedback Edit

.show table row order policy

  • Article
  • 2 minutes to read

Display a table's row order policy. The row order policy is an optional policy set on tables, that suggests the desired ordering of rows in a data shard. The purpose of the policy is to improve performance of queries which are known to be narrowed to a small subset of values in the ordered columns.

Syntax

.show table TableName policy roworder

Arguments

TableName - Specify the name of the table.

Returns

Returns a JSON representation of the policy.

Example

Delete the row order policy:

.show table events policy roworder