Oracle High Performance Tuning for 9i and 10g

P

Partitioning and parallelism, 545–58

benefits, 546–47

composite partitions, 555–56

definition, 545

hash partitions, 554–55

partitioning by list, 552–54

partitioning by range, 548–51

physical partitioning, 546

tables and indexes, 547–48

tricks with partitions, 556–58

Physical database and configuration tuning, definition, xv

Physical tuning, 17

PL/SQL (Programming Language for SQL), 188–91

Problem queries see Tools to detect problem queries

Programimg Language for SQL see PL/SQL