Performance Enhancement using SQL Statement Tuning Approach

oleh: Hitesh Kumar SHARMA, S.C. NELSON

Format: Article
Diterbitkan: Bucharest University of Economic Studies 2017-07-01

Deskripsi

Tuning your SQL statements may be one of the most important tasks you can do to improve the performance of your Oracle system. By tuning your SQL statements to be as efficient as possible, you use your system to its full potential. Some of the things you can do to improve the efficiency of your SQL statements may involve as little effort as rewriting the SQL to take advantage of some property of your database or perhaps even changing the structure of the database itself.