Best Software for 2025 is now live!
View the Winners
  1. Home
  2. ...
  3. Data Warehouse Solutions
  4. Snowflake
  5. Snowflake Discussions
  6. How do you optimize query performance in snowflake while analysing?
Akshaykumar J.
AJ
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
Expand/Collapse Social Share Options

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.
1 comment
Looks like you’re not logged in.
Users need to be logged in to answer questions
Log In
AR
0
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.
deleteedit
Looks like you’re not logged in.
Users need to be logged in to write comments
Log In
Reply
Already have Snowflake?

About Snowflake

Snowflake makes enterprise AI easy, efficient and trusted. Thousands of companies around the globe, including hundreds of the world’s largest, use Snowflake’s AI Data Cloud to share data, build applic
Discover More