LEADER 03156nam 22005655 450 001 9910254990703321 005 20200630222426.0 010 $a3-662-50417-0 024 7 $a10.1007/978-3-662-50417-8 035 $a(CKB)3710000000862111 035 $a(DE-He213)978-3-662-50417-8 035 $a(MiAaPQ)EBC4690726 035 $a(PPN)195508416 035 $a(EXLCZ)993710000000862111 100 $a20160916d2016 u| 0 101 0 $aeng 135 $aurnn|008mamaa 181 $ctxt$2rdacontent 182 $cc$2rdamedia 183 $acr$2rdacarrier 200 10$aFormal SQL Tuning for Oracle Databases $ePractical Efficiency - Efficient Practice /$fby Leonid Nossov, Hanno Ernst, Victor Chupis 205 $a1st ed. 2016. 210 1$aBerlin, Heidelberg :$cSpringer Berlin Heidelberg :$cImprint: Springer,$d2016. 215 $a1 online resource (XVI, 109 p. 68 illus., 13 illus. in color.) 311 $a3-662-50416-2 320 $aIncludes bibliographical references. 327 $aPrefaces -- Introduction -- Some thoughts concerning the term "SQL Tuning" -- Minimum minimorum to the subject "Execution Plan" -- Approaches to formal SQL Tuning -- Bottlenecks in Execution Plans -- Procedure for formal SQL Tuning -- Practical experiences with formal SQL Tuning -- Appendix -- Application of the formal method for analysis of performance issues following Oracle migration. 330 $aThe target of SQL tuning is the improvement of the existing execution plan. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently familiar with the data model. The book presents numerous practical examples with this method. 606 $aDatabase management 606 $aManagement information systems 606 $aComputer science 606 $aApplication software 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 606 $aManagement of Computing and Information Systems$3https://scigraph.springernature.com/ontologies/product-market-codes/I24067 606 $aComputer Appl. in Administrative Data Processing$3https://scigraph.springernature.com/ontologies/product-market-codes/I2301X 615 0$aDatabase management. 615 0$aManagement information systems. 615 0$aComputer science. 615 0$aApplication software. 615 14$aDatabase Management. 615 24$aManagement of Computing and Information Systems. 615 24$aComputer Appl. in Administrative Data Processing. 676 $a005.74 700 $aNossov$b Leonid$4aut$4http://id.loc.gov/vocabulary/relators/aut$0934411 702 $aErnst$b Hanno$4aut$4http://id.loc.gov/vocabulary/relators/aut 702 $aChupis$b Victor$4aut$4http://id.loc.gov/vocabulary/relators/aut 906 $aBOOK 912 $a9910254990703321 996 $aFormal SQL Tuning for Oracle Databases$92104174 997 $aUNINA