Books
in black and white
Main menu
Share a book About us Home
Books
Biology Business Chemistry Computers Culture Economics Fiction Games Guide History Management Mathematical Medicine Mental Fitnes Physics Psychology Scince Sport Technics
Ads

Teradata RDBMS Database Administration - NCR

NCR Teradata RDBMS Database Administration - NCR , 2004. - 616 p.
Download (direct link): teradatadatabaseadmin2004.pdf
Previous << 1 .. 2 3 4 5 < 6 > 7 8 9 10 11 12 .. 218 >> Next


Volatile versus Derived Tables.................................................................................2-19

Global versus Volatile Tables....................................................................................2-19

Indexes............................................................................................................................2-21

Primary Index (PI).........................................................................................................2-22

Using an Identity Column as a Primary Index......................................................2-24

Benefits of a Using a Partitioned Primary Index (PPI)..........................................2-25

Defining a PPI.............................................................................................................2-25

Working with PPIs........................................................................................................2-30

Row IDs of Partitioned Tables..................................................................................2-30

Table Header Partition Indicator Bit........................................................................2-31

System-Derived PARTITION Column....................................................................2-31

Referencing the PARTITION Column.....................................................................2-31

Controlling Memory Usage with PPICacheThrP..................................................2-33

Revalidating Primary Indexes..................................................................................2-33

Secondary Indexes (SI)..................................................................................................2-35

Creating a Secondary Index......................................................................................2-35

Proving Secondary Indexes.......................................................................................2-36

Join Indexes (JI)..............................................................................................................2-37

Hash Index (HI)..........................................................................................................2-37

Multiple Join Indexes and Memory Considerations.............................................2-39

Creating and Modifying Indexes................................................................................2-40

Dropping Indexes..........................................................................................................2-43

Costing and Validating Indexes..................................................................................2-44

Tradeoffs......................................................................................................................2-44

Verifying Behavior.....................................................................................................2-44

Collecting Optimizer Statistics....................................................................................2-45

Usage............................................................................................................................2-45

Benefits.........................................................................................................................2-46

Collecting Statistics on Indexes................................................................................2-46

Collecting Index Statistics with CREATE INDEX.................................................2-47

Re-Collecting Statistics...............................................................................................2-47

Data Dictionary Statistics Maintenance..................................................................2-47

Prototyping a Database................................................................................................2-49

xxviii

Teradata RDBMS Database Administration Contents

Prototyping Indexes...................................................................................................2-50

Prototyping a Primary Index....................................................................................2-51

Analyzing Row Distribution.....................................................................................2-51

Analyzing PI Performance .......................................................................................2-53

Analyzing Secondary Indexes with the Teradata Index Wizard........................2-53

Prototyping Join Indexes...........................................................................................2-54

Using a Partial-Covering Join Index........................................................................2-55

Prototyping a Single-Table, Partial-Covering Index.............................................2-55

Converting Non-Relational Data Structures.............................................................2-62
Previous << 1 .. 2 3 4 5 < 6 > 7 8 9 10 11 12 .. 218 >> Next