# How can I improve the read/write efficiency of Materialized Views with Global and Local Secondary Indexes?

**URL:** <https://forum.scylladb.com/t/how-can-i-improve-the-read-write-efficiency-of-materialized-views-with-global-and-local-secondary-indexes/5555>\
**Category:** ScyllaDB\
**Tags:** data-model, performance, materialized-views, secondary-index\
**Created:** [October 28, 2026, 7:12am UTC](https://forum.scylladb.com/t/how-can-i-improve-the-read-write-efficiency-of-materialized-views-with-global-and-local-secondary-indexes/5555 "2026-10-28T07:12:19Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Guy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/guy/32/9_2.png) [@Guy](https://forum.scylladb.com/u/Guy)\
**Post date:** [October 28, 2026, 7:12am UTC](https://forum.scylladb.com/t/how-can-i-improve-the-read-write-efficiency-of-materialized-views-with-global-and-local-secondary-indexes/5555/1 "2026-10-28T07:12:19Z")

</div>

> [@](#):
>
> **[Originally from the User Slack](https://scylladb-users.slack.com/)**
> 
> ![Mahdi_Kamali](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/2X/7/7fb1a0a118e8eb1518763300c376e9c0ce9db7bc.png) @Mahdi\_KamaliMahdi\_Kamali: I’m using a Materialized View with the same partition key as the base table including all table columns.  
> My purpose is to avoid both GSI’s inter-node communication and LSI’s “IN” statement to have efficient write mutations and read.  
> Is this the right solution?
> 
> ![avi](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/b5e08becda8d9df1abff1d3a2d9ffe1126ac3fc6.jpeg) @avi: yes (provided that’s what your queries look like too)