Formal SQL Tuning for Oracle Databases (Record no. 51604)
[ view plain ]
| 000 -LEADER | |
|---|---|
| fixed length control field | 02625nam a22005055i 4500 |
| 001 - CONTROL NUMBER | |
| control field | 978-3-662-50417-8 |
| 005 - DATE AND TIME OF LATEST TRANSACTION | |
| control field | 20200420220216.0 |
| 008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION | |
| fixed length control field | 160916s2016 gw | s |||| 0|eng d |
| 020 ## - INTERNATIONAL STANDARD BOOK NUMBER | |
| ISBN | 9783662504178 |
| -- | 978-3-662-50417-8 |
| 082 04 - CLASSIFICATION NUMBER | |
| Call Number | 005.74 |
| 100 1# - AUTHOR NAME | |
| Author | Nossov, Leonid. |
| 245 10 - TITLE STATEMENT | |
| Title | Formal SQL Tuning for Oracle Databases |
| Sub Title | Practical Efficiency - Efficient Practice / |
| 300 ## - PHYSICAL DESCRIPTION | |
| Number of Pages | XVI, 109 p. 68 illus., 13 illus. in color. |
| 505 0# - FORMATTED CONTENTS NOTE | |
| Remark 2 | Prefaces -- 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 ## - SUMMARY, ETC. | |
| Summary, etc | The 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. |
| 700 1# - AUTHOR 2 | |
| Author 2 | Ernst, Hanno. |
| 700 1# - AUTHOR 2 | |
| Author 2 | Chupis, Victor. |
| 856 40 - ELECTRONIC LOCATION AND ACCESS | |
| Uniform Resource Identifier | http://dx.doi.org/10.1007/978-3-662-50417-8 |
| 942 ## - ADDED ENTRY ELEMENTS (KOHA) | |
| Koha item type | eBooks |
| 264 #1 - | |
| -- | Berlin, Heidelberg : |
| -- | Springer Berlin Heidelberg : |
| -- | Imprint: Springer, |
| -- | 2016. |
| 336 ## - | |
| -- | text |
| -- | txt |
| -- | rdacontent |
| 337 ## - | |
| -- | computer |
| -- | c |
| -- | rdamedia |
| 338 ## - | |
| -- | online resource |
| -- | cr |
| -- | rdacarrier |
| 347 ## - | |
| -- | text file |
| -- | |
| -- | rda |
| 650 #0 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Computer science. |
| 650 #0 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Database management. |
| 650 #0 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Application software. |
| 650 #0 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Management information systems. |
| 650 14 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Computer Science. |
| 650 24 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Database Management. |
| 650 24 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Management of Computing and Information Systems. |
| 650 24 - SUBJECT ADDED ENTRY--SUBJECT 1 | |
| -- | Computer Appl. in Administrative Data Processing. |
| 912 ## - | |
| -- | ZDB-2-SCS |
No items available.