In terms of working with highly loaded databases, any badly-designed request can cause significant performance degradation. Depending on the used DBMS features, various methods are used for query optimization. However, a general rule can be pointed out for all types of DBMS: the fewer server resources are expended when executing…