# How do you optimize query performance in snowflake while analysing?

I ran a query in a dataset with 0.1 million rows for analysing the data using merge function. It took longer time than expected to fetch the records and run query.

##### Post Metadata
- Posted at: almost 4 years ago
- Author title: Seasoned professional with 5+ years of experience in IT industry|GCP Certified Professional Cloud Developer|Snowflake ❄️|Data Analyst|Python|Terraform|AWS|UNIX & LINUX|SQL|Data Warehousing|ETL|Teradata|IBM TWS
- Net upvotes: 1


## Comments
### Comment 1

1) Choosing the Right Virtual Warehouse size.
2) Using Caching in Snowflake.
3) Using Materialized Views.
4) Data clustering and micro-partitioning.
5) Using Snowflake Query Acceleration.
6) Making use of the Snowflake Query profile tool.
7) Using the Snowflake Search Optimization Service.

##### Comment Metadata
- Posted at: over 2 years ago




## Related Product
[Snowflake](https://www.g2.com/products/snowflake/reviews)

## Related Category
[Data Warehouse](https://www.g2.com/categories/data-warehouse)

## Related discussions
- [How well does Trello scale into a larger team?](https://www.g2.com/discussions/1-how-well-does-trello-scale-into-a-larger-team)
  - Posted at: almost 13 years ago
  - Comments: 6
- [Can we please add a new section](https://www.g2.com/discussions/2-can-we-please-add-a-new-section)
  - Posted at: almost 13 years ago
  - Comments: 0
- [Quantifiable benefits from implementing your CRM](https://www.g2.com/discussions/quantifiable-benefits-from-implementing-your-crm)
  - Posted at: almost 13 years ago
  - Comments: 4