Oracle high performance tuning for 9i and 10g /
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the a...
| Основен автор: | Powell, Gavin. |
|---|---|
| Формат: | Електронна книга |
| Език: | English |
| Публикувано: |
Amsterdam ; Boston :
Elsevier/Digital Press,
℗♭2004.
|
| Предмети: | |
| Онлайн достъп: |
http://search.ebscohost.com/login.aspx?direct=true&scope=site&db=nlebk&AN=320842 |
| Подобни документи: |
Print version::
Oracle high performance tuning for 9i and 10g. |
| Резюме: |
There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culpri. |
|---|---|
| Физически характеристики: |
1 online resource (xxxiv, 738 pages) : illustrations |
| ISBN: |
9780080513294 0080513298 1282540149 9781282540149 |