Hi! Does a shard key for a rowstore table which is not the primary key* have a skiplist index too? Or does a skiplist index need to be explicitly specified as well to optimize lookups?
*the column is a subset of the primary key but not the prefix
This is correct. On a rowstore table when you specify the shard key that is not the primary key a skiplist index will also implicitly be created on the shard key columns.
3 Likes
That is perfect. Thanks so much!
1 Like