u/fururo

Oi amigos!
A pergunta vai pra quem já atua na área, quais coisas vocês fazem pra otimizar consultas no sql? Não atuo como engenheiro, sou analista! Porém atuo diretamente na camada gold faço tabelas e views e são muitas tabelas muitas informações e as vezes fico perdido em como otimizar consultas, tenho sentido elas mais lentas.
Vocês tem dicas de conteúdo, livros ou que vocês usam pra melhorar suas consultas? Já leio os planos de execução e ainda sim fico perdido.

Hello guys!

Do you know any best practices for SQL performance optimization?
At my company, I need to refactor some tables using performance and cost reduction best practices.

The tables already have indexes and partitions, but I would like to learn more about additional optimization techniques for large datasets.

Do you have any tips, articles, websites, or recommendations about: query optimization and indexing strategies

I’d really appreciate any suggestions or learning resources. Thanks!

Hello guys!

Do you know any best practices for SQL performance optimization?
At my company, I need to refactor some tables using performance and cost reduction best practices.

The tables already have indexes and partitions, but I would like to learn more about additional optimization techniques for large datasets.

Do you have any tips, articles, websites, or recommendations about: ,query optimization and indexing strategies
I’d really appreciate any suggestions or learning resources. Thanks!