# Using IN in a query for a specific partition, is the entire partition fetched?

**URL:** <https://forum.scylladb.com/t/using-in-in-a-query-for-a-specific-partition-is-the-entire-partition-fetched/2340>\
**Category:** ScyllaDB\
**Tags:** data-model, performance\
**Created:** [July 23, 2024, 6:09am UTC](https://forum.scylladb.com/t/using-in-in-a-query-for-a-specific-partition-is-the-entire-partition-fetched/2340 "2024-07-23T06:09:38Z")\
**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:** [July 23, 2024, 6:09am UTC](https://forum.scylladb.com/t/using-in-in-a-query-for-a-specific-partition-is-the-entire-partition-fetched/2340/1 "2024-07-23T06:09:38Z")

</div>

> [@](#):
>
> [**Originally from the User Slack**](https://scylladb-users.slack.com/)
> 
> ![raghav_tandon](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/2X/3/32724e26aa5bcc217f4cce75e5c387efe0023e72.jpeg) **@raghav\_tandon:** Hi, have a small question…  
> If i have a partition with key/value pair and partition size will never go beyond 200kB.  
> So, if i do `IN` query (for specific partition) to fetch only some keys would that be beneficial or scylla will always fetch entire partition and we will only save on network.
> 
> ![avi](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/b5e08becda8d9df1abff1d3a2d9ffe1126ac3fc6.jpeg) **@avi:** It will likely fetch the entire partition, but you can check with tracing
> 
> ![raghav_tandon](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/2X/3/32724e26aa5bcc217f4cce75e5c387efe0023e72.jpeg) **@raghav\_tandon:** so we have a design decision to make like a blob with a everything in one column or as a key/value store… if entire partition is fetched then both would give same performance?
> 
> ![avi](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/b5e08becda8d9df1abff1d3a2d9ffe1126ac3fc6.jpeg) **@avi:** It’s generally better to have separate rows/columns rather than blobs (esp if they’re modified separately)
> 
> ![raghav_tandon](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/2X/3/32724e26aa5bcc217f4cce75e5c387efe0023e72.jpeg) **@raghav\_tandon:** sure, Thanks for the clarification