Will a data table and its index table split simultaneously

Hi.
Excuse me, when creating an index for one field in a data table, does a node of the cluster only fill in the index for local tablet data of the data table? Or rather, the data filling of the index is cross node?
When the data of this data table continues to increase and needs to be split into multiple tablets, will the index table split along with it?
Does the sharded data of the split index correspond to the sharded data of the data table’s tablet?

Hi @ZhenNan2016

The table & index locations for a given row can be on different nodes of the cluster (except colocated db where they’re together).

No. The tables/indexes are split into “tablets”. The tablets split on their own.

No. Think of an index as a separate table that gets inserts/deletes from the main table. The splitting logic is separate.

Hi @dorian_yugabyte
I have a requirement now that I can build my own index data on the main table data of this node, without crossing nodes. This way, when searching for data, it can be locked on the same node, reducing the performance overhead caused by cross location. For example, if the tablet data of the main table on the node A is 1-100 rows of data, then the index data on the node A also belongs to the index data of these 1-100 rows.
Is there any good way to support this requirement?

@dorian_yugabyte
From the following online-index-backfill.md document, it appears that a node of the cluster only fill in the index for local tablet data of the data table?

This is not possible, see Co-partitioned tables · Issue #79 · yugabyte/yugabyte-db · GitHub

You can create multiple colocated dbs as an example, but that overheads that you can’t share connections, can’t join/transact data across dbs, have to handle DDL for each db etc.

Yes, local tablet data. For each row in that tablet, the index-tablet may be in another server.