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.
Produkteigenschaften
- Artikelnummer: 9781555583453
- Medium: Buch
- ISBN: 978-1-55558-345-3
- Verlag: Elsevier Science
- Erscheinungstermin: 01.09.2006
- Sprache(n): Englisch
- Auflage: 2. Auflage 2006
- Produktform: Kartoniert
- Gewicht: 1606 g
- Seiten: 960
- Format (B x H x T): 192 x 234 x 37 mm
- Ausgabetyp: Kein, Unbekannt
- Vorauflage: 978-1-55558-305-7
