Boas práticas de tuning de banco de dados para otimização de um banco de dados relacional

Abstract

With the advancement of technology, we have entered an era with a large accumulation of data, such data have several applications generating their own values, for their control and management, we have structures and tools to make the greatest amount of data available in the smallest amount. possible time, since there are limits for certain tools to guarantee a certain level of performance, it is up to manual optimization to continue this process, through well-defined best practices to increasingly improve the performance of a relational database. Such best practices are addressed from the construction of queries in sql to the most appropriate use of storage media, making it clear how the use of best practices significantly contributes to the optimization of a relational database.