Menu
Rendelés állapotának ellenőrzése
Kapcsolat
Könyv Relational Database Index Design and the Optimizers - DB2, Oracle, SQL Server, et al. Lahdenmaki

Relational Database Index Design and the Optimizers - DB2, Oracle, SQL Server, et al.

Szerző: Lahdenmaki
Nyelv: Angol
Kötés: Kemény kötésű
Kiadó: John Wiley & Sons Inc
Elérhetőség: Beszállítói készleten
Küldés 9-15 napon belül
50 661 Ft
Improve the performance of relational databases with indexes designed for today's hardware Over the...

Információk a könyvről

Szerző
Lahdenmaki
Nyelv
Angol
Kötés
Könyv - Kemény kötésű
Kiadva
2005
oldal
328
EAN
9780471719991
ISBN
0471719994
Enbook ID
04085692
Kiadó
John Wiley & Sons Inc
Súly
696
Méretek
251 x 166 x 26

Teljes leírás

Improve the performance of relational databases with indexes designed for today's hardware Over the last few years, hardware and software have advanced beyond all recognition, so it's hardly surprising that relational database performance now receives much less attention. Unfortunately, the reality is that the improved hardware hasn't kept pace with the ever-increasing quantity of data processed today. Although disk packing densities have increased enormously, making storage costs extremely low and sequential read very fast, random reads are still painfully slow. Many of the old design recommendations are therefore no longer valid-the optimal point of indexing has come a long way. Consequently many of the old problems haven't actually gone away-they have simply changed their appearance. This book provides an easy but effective approach to the design of indexes and tables. Using lots of examples and case studies, the authors describe how the DB2, Oracle, and SQL Server optimizers determine how to access data, and how CPU and response times for the resulting access paths can be quickly estimated. This enables comparisons to be made of the various designs, and helps you choose available choices for the most appropriate design. This book is intended for anyone who wants to understand the issues of SQL performance or how to design tables and indexes effectively. With this title, readers with many years of experience of relational systems will be able to better grasp the implications that have been brought into play by the introduction of new hardware. An Instructor's Manual presenting detailed solutions to all the problems in the book is available online from the Wiley editorial department. An Instructor Support FTP site is also available.

Érdekelheti

SQL Tuning

Dan Tow
11 439 Ft

SQL in a Nutshell

Regina O. Obe
22 508 Ft

Murach's SQL Server 2022 for Developers

Bryan Syverson
23 665 Ft

SQL Query Design Patterns and Best Practices: A practical guide to writing readable and maintainable SQL queries using its design patterns

Dennis Neer
13 398 Ft

SQL Tuning

Dan Tow
9 332 Ft

The Foundations Of England: Or Twelve Centuries Of British History B.C. 55 To A.D. 1154

James H. Ramsay
15 490 Ft

The Missionary Position

Christopher Hitchens
3 700 Ft

Landscape Painter's Workbook

MITCHELL ALBALA
7 863 Ft

SNES Encyclopedia

CHRIS SCULLION
8 714 Ft

Tyranny of Merit

Michael J. Sandel
4 123 Ft

FINDING RADHA-

Namita
5 183 Ft

1177 B.C.- The Year Civilization Collapsed - Revised and Updated

Eric H. Cline
5 646 Ft

Alchemy of Stones

Robert Simmons
8 696 Ft

Caged Lion

John Howard Steel
4 813 Ft

How To Out Think Your Opponent: Or T. N. Tactics For Close In Fighting (1918)

Al Williams
7 823 Ft

Harry Potter and the Philosopher's Stone

Joanne K. Rowling
14 132 Ft

Meditations

Marcus Aurelius
4 403 Ft

DK Eyewitness Venice and the Veneto

Dk Travel
8 780 Ft

Sapientia Astrologica: Astrology, Magic and Natural Knowledge, ca. 1250-1800

H Darrel Rutkin
53 484 Ft

Burnout

Emily Nagoski
8 696 Ft

Visual Guitar Theory: An Easy Guide to Recognizing and Understanding Essential Fretboard Patterns

Chad Johnson
5 379 Ft

Coloss Bee Book Vol II

VINCENT DIETEMANN
28 380 Ft

What Causes Human Behavior: Stars, Selves, or Contingencies?

Stephen F LeDoux
14 262 Ft

Myth of Normal

Gabor Maté
4 831 Ft