000 02625nam a22005055i 4500
001 978-3-662-50417-8
003 DE-He213
005 20200420220216.0
007 cr nn 008mamaa
008 160916s2016 gw | s |||| 0|eng d
020 _a9783662504178
_9978-3-662-50417-8
024 7 _a10.1007/978-3-662-50417-8
_2doi
050 4 _aQA76.9.D3
072 7 _aUN
_2bicssc
072 7 _aUMT
_2bicssc
072 7 _aCOM021000
_2bisacsh
082 0 4 _a005.74
_223
100 1 _aNossov, Leonid.
_eauthor.
245 1 0 _aFormal SQL Tuning for Oracle Databases
_h[electronic resource] :
_bPractical Efficiency - Efficient Practice /
_cby Leonid Nossov, Hanno Ernst, Victor Chupis.
264 1 _aBerlin, Heidelberg :
_bSpringer Berlin Heidelberg :
_bImprint: Springer,
_c2016.
300 _aXVI, 109 p. 68 illus., 13 illus. in color.
_bonline resource.
336 _atext
_btxt
_2rdacontent
337 _acomputer
_bc
_2rdamedia
338 _aonline resource
_bcr
_2rdacarrier
347 _atext file
_bPDF
_2rda
505 0 _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.
520 _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.
650 0 _aComputer science.
650 0 _aDatabase management.
650 0 _aApplication software.
650 0 _aManagement information systems.
650 1 4 _aComputer Science.
650 2 4 _aDatabase Management.
650 2 4 _aManagement of Computing and Information Systems.
650 2 4 _aComputer Appl. in Administrative Data Processing.
700 1 _aErnst, Hanno.
_eauthor.
700 1 _aChupis, Victor.
_eauthor.
710 2 _aSpringerLink (Online service)
773 0 _tSpringer eBooks
776 0 8 _iPrinted edition:
_z9783662504161
856 4 0 _uhttp://dx.doi.org/10.1007/978-3-662-50417-8
912 _aZDB-2-SCS
942 _cEBK
999 _c51604
_d51604