
Tuning of SQL code is generally cheaper than changing the data model. Physical and configuration tuning involves a search for bottlenecks that often points to SQL code or data model issues. Building an appropriate data model and writing properly performing SQL code can give 100%+ performance improvement. Physical and configuration tuning often gives at most a 25% performance increase.
Gavin Powell shows that the central theme of Oracle10gR2 Performance Tuning is four-fold: denormalize data models to fit applications; tune SQL code according to both the data model and the application in relation to scalability; create a well-proportioned physical architecture at the time of initial Oracle installation; and most important, mix skill sets to obtain the best results.
* Fully updated for version 10gR2 and provides all necessary transition material from version 9i
* Includes all three aspects of Oracle database tuning: data model tuning, SQL & PL/SQL code tuning, physical plus configuration tuning
* Contains experienced guidance and real-world examples using large datasets Emphasizes development as opposed to operating system perspective
http://rapidshare.com/files/45245706/Oracle.Performance.Tuning.for.10gR2.Second.Ed.1555583458.rar
SQL The Complete Reference, 3rd Edition
MySQL in a Nutshell (In a Nutshell (O'Reilly))
High Performance MySQL SECOND EDITION
Oracle SQL Tuning Pocket Reference
SQL Clearly Explained, Second Edition
MySQL (4th Edition) (Developer's Library)
Pro SQL Server Reporting Services
Wrox Professional SQL Server 2005 Reporting Services
SQL Hacks
Pro Access 2007
Fundamentals of Database Systems (4th Ed(9201)
Introduction to Database Systems(7705)
Oracle PL/SQL by Example, 4th Edition(7460)
Microsoft SQL Server 2005, The Complete (4859)
Microsoft Access 2007 Data Analysis(4849)
OCA Oracle Database 11g: Administration (4783)
SQL Server 2005 Management and Administr(4428)
Oracle Database 10g Performance Tuning T(4256)
Oracle SQL by Example(4115)
Database Design: Know It All(3882)
Sams Teach Yourself SQL in 24 Hours (4th(3683)
Database Management Systems(3619)
Access 2007 VBA Programmer's Reference(3413)
Professional Microsoft SQL Server 2008 I(2971)
MySQL in a Nutshell (In a Nutshell (O'Re(10-28)
High Performance MySQL SECOND EDITION(10-28)
Oracle SQL Tuning Pocket Reference(10-28)
SQL Clearly Explained, Second Edition(07-14)
MySQL (4th Edition) (Developer's Library(07-09)
Pro SQL Server Reporting Services(05-28)
Wrox Professional SQL Server 2005 Report(05-28)
SQL Hacks(05-09)
Pro Access 2007(05-04)
Administering SQL Server 7(12-31)
Database Design: Know It All(12-15)
Professional Microsoft SQL Server 2008 I(12-06)
Fundamentals of Database Systems (4th Ed(11-18)
SQL Clearly Explained, Second Edition(10-31)
