Considerations on SQL Optimization Tools in MS Azure SQL Server Database using SQL language

Abstract

Databases are essential since are designed to stored and organized data that can be easily managed and accessed. They are crucial to many organizations, companies, and are used in many aspects of our lives. The relational database, based on the relational model, and represented in a tabular way, is one of the most used. Relational database management systems are used to maintain them. One of the most known languages for querying and maintaining relational databases is the Structured Query Language. On this paper article, the researcher explored different optimization tools in MS Azure SQL Server Database that could bring information that could help students and developers to optimize their queries and improve performance. Key Terms ⎯ Query Plans, Query Profiler, SQL Optimization Tools, and Structured query language (SQL).