The present disclosure provides a method and system to reduce scan time for single user query using a query processing system. The query processing system receives a first set of data. In addition, the query processing system obtains a second set of data. Further, the query processing system fetches a third set of data. Furthermore, the query processing system stores the first set of data, the second set of data, and the third set of data in a first shard of a plurality of shards. Moreover, the query processing system collects the first set of data, the second set of data, and the third set of data in a first memory region of a plurality of memory regions. Also, the query processing system receives a query request from an administrator. Also, the query processing system scans the first memory region of the plurality of memory regions of the first shard.