The thesis analyses tools, which offers Oracle Database 11g R2 for tuning SQL statements. Tools are then used in reporting section of real banking system to optimize SQL statements. Then are created test cases and results are analyzed with categorization to prove successful optimization. In the end are evaluated benefits of the optimization and created advices for next progress in optimization.
| Identifer | oai:union.ndltd.org:nusl.cz/oai:invenio.nusl.cz:165099 |
| Date | January 2011 |
| Creators | Valerián, Martin |
| Contributors | Chlapek, Dušan, Palovská, Helena |
| Publisher | Vysoká škola ekonomická v Praze |
| Source Sets | Czech ETDs |
| Language | Czech |
| Detected Language | English |
| Type | info:eu-repo/semantics/masterThesis |
| Rights | info:eu-repo/semantics/restrictedAccess |
Page generated in 0.0024 seconds