# \#secondary-index **URL:** https://forum.scylladb.com/tag/secondary-index/99.md [Latest](https://forum.scylladb.com/latest.md) · [Categories](https://forum.scylladb.com/categories.md) · [Tags](https://forum.scylladb.com/tags.md) --- ## [Will inconsistencies between the base table and the GSI table be detected?](https://forum.scylladb.com/t/will-inconsistencies-between-the-base-table-and-the-gsi-table-be-detected/2910)
**Author:** [@bo\_li](https://forum.scylladb.com/u/bo_li)\ **Replies:** 10\ **Last updated:** [May 8, 2026, 11:59pm UTC](https://forum.scylladb.com/t/will-inconsistencies-between-the-base-table-and-the-gsi-table-be-detected/2910 "2026-05-08T23:59:09Z")
I tried deleting some SSTables files of the base table, then restarting scylla and performing repair on only the base table. At this time, I found that new data will be generated in the memtable, and the data is written … --- ## [Tablets configuration error after migration to newer version, materialized views and secondary indexes](https://forum.scylladb.com/t/tablets-configuration-error-after-migration-to-newer-version-materialized-views-and-secondary-indexes/5303)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [March 8, 2026, 8:35am UTC](https://forum.scylladb.com/t/tablets-configuration-error-after-migration-to-newer-version-materialized-views-and-secondary-indexes/5303 "2026-03-08T08:35:50Z")
--- ## [Whats the correct model schema for my use case?](https://forum.scylladb.com/t/whats-the-correct-model-schema-for-my-use-case/5148)
**Author:** [@Cezar\_Lacatus](https://forum.scylladb.com/u/Cezar_Lacatus)\ **Replies:** 8\ **Last updated:** [October 28, 2025, 8:51am UTC](https://forum.scylladb.com/t/whats-the-correct-model-schema-for-my-use-case/5148 "2025-10-28T08:51:38Z")
Hello, I am the owner of a roblox extension and I had recently encounter dificulties with ScyllaDB that made me consider switching to MongoDB. My application is stable right now but I want to know what I did wrong in my … --- ## [Why does a token-unaware query involving a local secondary index require a round trip?](https://forum.scylladb.com/t/why-does-a-token-unaware-query-involving-a-local-secondary-index-require-a-round-trip/4976)
**Author:** [@klawson88](https://forum.scylladb.com/u/klawson88)\ **Replies:** 1\ **Last updated:** [July 28, 2025, 5:59pm UTC](https://forum.scylladb.com/t/why-does-a-token-unaware-query-involving-a-local-secondary-index-require-a-round-trip/4976 "2025-07-28T17:59:52Z")
According to the documentation on local secondary indexes, the read path for token-unaware queries involving a local secondary index (LSI) are not completely satisfied locally. Instead, the keys retrieved from the LSI on… --- ## [Is High-Cardinality Partition Key a Problem in ScyllaDB?](https://forum.scylladb.com/t/is-high-cardinality-partition-key-a-problem-in-scylladb/4874)
**Author:** [@process\_clock\_tick](https://forum.scylladb.com/u/process_clock_tick)\ **Replies:** 1\ **Last updated:** [June 6, 2025, 9:27am UTC](https://forum.scylladb.com/t/is-high-cardinality-partition-key-a-problem-in-scylladb/4874 "2025-06-06T09:27:46Z")
Installation details #ScyllaDB version: 5.2 os (RHEL/CentOS/Ubuntu/AWS AMI): CentOS I’m designing a ScyllaDB table where each partition is tied to a unique job\_id, which is a UUID. Each job typically inserts a small … --- ## [Why use update\_entry in view\_updates?](https://forum.scylladb.com/t/why-use-update-entry-in-view-updates/4545)
**Author:** [@bo\_li](https://forum.scylladb.com/u/bo_li)\ **Replies:** 2\ **Last updated:** [March 10, 2025, 11:45am UTC](https://forum.scylladb.com/t/why-use-update-entry-in-view-updates/4545 "2025-03-10T11:45:06Z")
Installation details #ScyllaDB version: master #Cluster size: 1 os (RHEL/CentOS/Ubuntu/AWS AMI): centos I noticed that when a view update is generated, it determines whether to use create\_entry or update\_entry based… --- ## [Indexes, Materialized Views and Disk Usage in Monitoring](https://forum.scylladb.com/t/indexes-materialized-views-and-disk-usage-in-monitoring/3117)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [October 29, 2024, 4:38pm UTC](https://forum.scylladb.com/t/indexes-materialized-views-and-disk-usage-in-monitoring/3117 "2024-10-29T16:38:59Z")
--- ## [Implement transaction in client side](https://forum.scylladb.com/t/implement-transaction-in-client-side/3082)
**Author:** [@jerome](https://forum.scylladb.com/u/jerome)\ **Replies:** 1\ **Last updated:** [October 28, 2024, 3:14pm UTC](https://forum.scylladb.com/t/implement-transaction-in-client-side/3082 "2024-10-28T15:14:28Z")
Howdy people! This is my first post on this forum, but I’ve been using ScyllaDB for the better part of this year. My use case requires the use of transactions. This means updating a group of records across partitions wi… --- ## [Limitations of tiny partitions](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103)
**Author:** [@sandeepm](https://forum.scylladb.com/u/sandeepm)\ **Replies:** 3\ **Last updated:** [October 28, 2024, 2:29pm UTC](https://forum.scylladb.com/t/limitations-of-tiny-partitions/3103 "2024-10-28T14:29:09Z")
I am having around 150 million rows in a table. Each row is a partition which means 150 million partitions. Size of each partition is 24kb. I know that small partitions work perfectly for even distribution of data witho… --- ## [Secondary indexes vs. denormalized tables](https://forum.scylladb.com/t/secondary-indexes-vs-denormalized-tables/2997)
**Author:** [@elyzk](https://forum.scylladb.com/u/elyzk)\ **Replies:** 1\ **Last updated:** [October 4, 2024, 8:17pm UTC](https://forum.scylladb.com/t/secondary-indexes-vs-denormalized-tables/2997 "2024-10-04T20:17:08Z")
Hey. I’m writing a database that contains guilds and channels. Guilds can have multiple channels, but channel IDs are unique and each channel can only belong to a single guild. I want my channel table to be indexable by … --- ## [Querying an Index via Alternator results in a different behavior than DynamoDB](https://forum.scylladb.com/t/querying-an-index-via-alternator-results-in-a-different-behavior-than-dynamodb/2917)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [September 19, 2024, 5:02am UTC](https://forum.scylladb.com/t/querying-an-index-via-alternator-results-in-a-different-behavior-than-dynamodb/2917 "2024-09-19T05:02:14Z")
@Joseph\_Stroman: The expected behavior is Alternator would return all the items it can and if there are leftovers then provide the last evaluated key (cursor) to continue “paginating” through the table. It looks like t… --- ## [Creating an index on User Defined Types](https://forum.scylladb.com/t/creating-an-index-on-user-defined-types/2178)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [June 18, 2024, 8:42am UTC](https://forum.scylladb.com/t/creating-an-index-on-user-defined-types/2178 "2024-06-18T08:42:42Z")
--- ## [Slow queries when indexing, BYPASS CACHE and non-expired tombstones](https://forum.scylladb.com/t/slow-queries-when-indexing-bypass-cache-and-non-expired-tombstones/2150)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [June 10, 2024, 5:54am UTC](https://forum.scylladb.com/t/slow-queries-when-indexing-bypass-cache-and-non-expired-tombstones/2150 "2024-06-10T05:54:02Z")
--- ## [Data Modeling question with a high consistency requirement, using LWT, MV, SI or frozen maps?](https://forum.scylladb.com/t/data-modeling-question-with-a-high-consistency-requirement-using-lwt-mv-si-or-frozen-maps/2108)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [June 2, 2024, 3:54am UTC](https://forum.scylladb.com/t/data-modeling-question-with-a-high-consistency-requirement-using-lwt-mv-si-or-frozen-maps/2108 "2024-06-02T03:54:11Z")
--- ## [Data Modeling question, choosing the Partition Key, Clustering Key, Indexing and performance impact](https://forum.scylladb.com/t/data-modeling-question-choosing-the-partition-key-clustering-key-indexing-and-performance-impact/2060)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [May 22, 2024, 5:06am UTC](https://forum.scylladb.com/t/data-modeling-question-choosing-the-partition-key-clustering-key-indexing-and-performance-impact/2060 "2024-05-22T05:06:13Z")
--- ## [Can we use tombstone\_gc = {'mode': 'repair'} for GSI tables?](https://forum.scylladb.com/t/can-we-use-tombstone-gc-mode-repair-for-gsi-tables/1273)
**Author:** [@vincent](https://forum.scylladb.com/u/vincent)\ **Replies:** 7\ **Last updated:** [May 20, 2024, 7:32am UTC](https://forum.scylladb.com/t/can-we-use-tombstone-gc-mode-repair-for-gsi-tables/1273 "2024-05-20T07:32:21Z")
I have two questions here about tombstone\_gc = {‘mode’: ‘repair’} for GSI tables. I am not sure whether tombstone\_gc = {‘mode’: ‘repair’} is supported for GSI tables or not. How can I ensure that the tombstone\_gc mode … --- ## [Materialized Views and Indexing, filtering columns by range, ALLOW FILTERING](https://forum.scylladb.com/t/materialized-views-and-indexing-filtering-columns-by-range-allow-filtering/1974)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [May 8, 2024, 3:42am UTC](https://forum.scylladb.com/t/materialized-views-and-indexing-filtering-columns-by-range-allow-filtering/1974 "2024-05-08T03:42:18Z")
--- ## [Querying by non partition key column, creating an index](https://forum.scylladb.com/t/querying-by-non-partition-key-column-creating-an-index/1436)
**Author:** [@Guy](https://forum.scylladb.com/u/Guy)\ **Replies:** 0\ **Last updated:** [March 31, 2024, 8:05am UTC](https://forum.scylladb.com/t/querying-by-non-partition-key-column-creating-an-index/1436 "2024-03-31T08:05:10Z")