Performance Enhancement using SQL Statement Tuning Approach
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...
| Main Authors: | , |
|---|---|
| Format: | Article |
| Language: | English |
| Published: |
Bucharest University of Economic Studies
2017-07-01
|
| Series: | Database Systems Journal |
| Subjects: | |
| Online Access: | http://www.dbjournal.ro/archive/27/27_2.pdf |
| _version_ | 1797709264710533120 |
|---|---|
| author | Hitesh Kumar SHARMA S.C. NELSON |
| author_facet | Hitesh Kumar SHARMA S.C. NELSON |
| author_sort | Hitesh Kumar SHARMA |
| collection | DOAJ |
| description | 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. |
| first_indexed | 2024-03-12T06:33:58Z |
| format | Article |
| id | doaj.art-4b9c9d03d35b49f8a6828537a7c8d1fc |
| institution | Directory Open Access Journal |
| issn | 2069-3230 2069-3230 |
| language | English |
| last_indexed | 2024-03-12T06:33:58Z |
| publishDate | 2017-07-01 |
| publisher | Bucharest University of Economic Studies |
| record_format | Article |
| series | Database Systems Journal |
| spelling | doaj.art-4b9c9d03d35b49f8a6828537a7c8d1fc2023-09-03T01:25:55ZengBucharest University of Economic StudiesDatabase Systems Journal2069-32302069-32302017-07-01VIII11221Performance Enhancement using SQL Statement Tuning ApproachHitesh Kumar SHARMA0S.C. NELSON1University of Petroleum & Energy Studies, Dehardun, Uttarakhand, IndiaUniversity of Petroleum & Energy Studies, Dehardun, Uttarakhand, IndiaTuning 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.http://www.dbjournal.ro/archive/27/27_2.pdfSQL tuningOracle databaseExplain Plan |
| spellingShingle | Hitesh Kumar SHARMA S.C. NELSON Performance Enhancement using SQL Statement Tuning Approach Database Systems Journal SQL tuning Oracle database Explain Plan |
| title | Performance Enhancement using SQL Statement Tuning Approach |
| title_full | Performance Enhancement using SQL Statement Tuning Approach |
| title_fullStr | Performance Enhancement using SQL Statement Tuning Approach |
| title_full_unstemmed | Performance Enhancement using SQL Statement Tuning Approach |
| title_short | Performance Enhancement using SQL Statement Tuning Approach |
| title_sort | performance enhancement using sql statement tuning approach |
| topic | SQL tuning Oracle database Explain Plan |
| url | http://www.dbjournal.ro/archive/27/27_2.pdf |
| work_keys_str_mv | AT hiteshkumarsharma performanceenhancementusingsqlstatementtuningapproach AT scnelson performanceenhancementusingsqlstatementtuningapproach |