Clark Perucho
May 20, 2022

--

Thanks for the feedback Prashant! The main point on the CTE part is to avoid multiple calls of the same object to minimize duplicate retrieves and reduce the amount of data to be processed. I've used CTE in this case and it proved to be more performant and resource-efficient.

Sign up to discover human stories that deepen your understanding of the world.

Free

Distraction-free reading. No ads.

Organize your knowledge with lists and highlights.

Tell your story. Find your audience.

Membership

Read member-only stories

Support writers you read most

Earn money for your writing

Listen to audio narrations

Read offline with the Medium app

--

--

Clark Perucho
Clark Perucho

Written by Clark Perucho

Snowflake Data Superhero | Certified SnowPro: Administrator | Teradata 14 Certified Technical Specialist

Responses (1)

Write a response