index_T

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

table altering tools 2nd 3rd
table authority query
TABLE class privileges
TABLE DB2 object
TABLE DCCSID column
        PLAN TABLE
table editors tools 2nd
TABLE ENCODE column
        PLAN TABLE
table expressions
        advantages 2nd
        common.
        multiple table data retrieval
        performance, improving 2nd
        views, compared
table functions 2nd
TABLE MCCSID column
        PLAN TABLE
table references
       unqualified
                DCLGEN statements
TABLE SCCSID column
        PLAN TABLE
table spaces
        backing up
        caching
        clustering index, ignoring
        compressing
                advantages
                disadvantages
                third-party solutions 2nd
        data pages 2nd
        data, erasing
        DB2 Catalog 2nd
        DB2 Directory 2nd
        DBD01
        defining
        DSN1CHKR utility
        encoding schemes 2nd
        free space 2nd 3rd
                calculating
                growth rate formula
                insert activity
                space search algorithm
       large
                DSN1COPY utility
                LOBs
        LOB 2nd
                data sets
                DSN1COPY utility
                DSN1PRNT utility
                encoding schemes
                names
                REORG phases
                VSAMdata sets
        LOB locks
        locking 2nd
        locks 2nd 3rd 4th 5th 6th
                compatibility
        modified pages, tracking
        multi-table 2nd
                code/reference tables
                DBD growth
                multiple tables, defining 2nd
                referential integrity
                single tables, defining
       multi-table simple
                loading
        multiple
                recovering
        names
       non-segmented
                space search algorithm
        online activity
        page size 2nd
       parameters
                BUFFERPOOL 2nd 3rd 4th
                CCSID 2nd
                CLOSE 2nd 3rd
                COMPRESS 2nd 3rd 4th
                DSNZPARM 2nd
                DSSIZE
                ERASE
                FREEPAGE 2nd 3rd
                LARGE 2nd 3rd
                LOCKMAX
                LOCKMAX 0
                LOCKPART
                LOCKSIZE 2nd 3rd
                LOCKSIZE ROW
                MAXROWS
                MAXROWS 1
                MEMBER CLUSTER
                NUMPARTS
                PCTFREE 2nd 3rd
                PRIQTY 2nd 3rd 4th 5th
                PRIQTY.
                SECQTY 2nd 3rd 4th 5th
                SEGSIZE
                TRACKMOD
                USING 2nd 3rd
        paramters
        partition locking
        partitioned
                advantages 2nd 3rd
                clustering
                creating
                DASD volumes
                data set sizes 2nd
                disadvantages 2nd
                distributing
                indexes
                large 2nd 3rd
                maximum size
                multiple tables, compared 2nd 3rd 4th 5th
                partition key ranges
                partition key updates
                size
                SMS 2nd
                starting/stopping
                table-controlled 2nd
                three-partition example 2nd 3rd
       pending states
                correcting 2nd 3rd
                reasons for 2nd
        recovering
        REORG phases 2nd
       reorganizing
                regular 2nd
                six special 2nd
        RI related
        row maximum 2nd
        sample
        SCT01
        segmented 2nd 3rd
                MQTs
                multiple tables, defining 2nd
                space search algorithm
                storin
        simple 2nd
        single
        space search algorithm 2nd
        SPT02
        statistics
        storing 2nd 3rd
                primary storage 2nd 3rd 4th 5th
                secondary storage 2nd 3rd 4th 5th
        SYSCOPY
        SYSDBASE
        SYSDBAUT
        SYSDDF
        SYSGPAUT
        SYSGROUP
        SYSGRTNS
        SYSJAVA
        SYSLGRNX
        SYSOBJ
        SYSPKAGE
        SYSPLAN
        SYSSEQ2
        SYSSTATS
        SYSSTR
       system
                recovering
        SYSUSER
        SYSUTILX
        SYSVIEWS
        types
                partitioned 2nd
       VSAM data sets
                closing 2nd 3rd
TABLE TYPE column
        PLAN TABLE
table UDFs
        cardinality, overriding
table user -defined functions
table-controlled partitioning 2nd
tables
        auditable
        auditing
       auxiliary
                creating
                indexes
                names
                navigational queries
        average per database query
       base
                views, creating 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th
       buffer pools
                isolating
        CDB 2nd
        CICS 2nd
                FCT
                PCT
                PPT
                RCT
       code
                multi-table table spaces
        column average per
        column labels
        columns 2nd
                abbreviation standards
                compressing
                data types 2nd
                data types, selecting 2nd 3rd
                date/time data
                date/time stamp 2nd
                decimal
                defaults 2nd
                defining
                homonyms
                identity 2nd 3rd 4th
                integer 2nd
                names
                nullable
                nulls 2nd 3rd 4th
                ROWID
                sequence objects 2nd 3rd 4th
                sequencing 2nd
                surrogate keys
                synonyms
                variable character 2nd 3rd 4th 5th 6th
                wasted space
       combined
                base table views
                denormalization
        comments
        converting to MQTs 2nd
       DB2
                declaring
        DB2 Catalog 2nd 3rd 4th 5th
                IPLIST
                IPNAMES
                LOCATIONS
                LULIST
                LUMODES
                LUNAMES
                MODESELECT
                SYSAUXRELS
                SYSCHECKDEP
                SYSCHECKS
                SYSCHECKS2
                SYSCOLAUTH 2nd 3rd
                SYSCOLDIST
                SYSCOLDIST_HIST
                SYSCOLDISTSTATS
                SYSCOLSTATS
                SYSCOLUMNS
                SYSCOLUMNS_HIST
                SYSCONSTDEP
                SYSCOPY
                SYSDATABASE
                SYSDATATYPES
                SYSDBAUTH
                SYSDBRM
                SYSDUMMY1
                SYSFIELDS
                SYSFOREIGNKEYS
                SYSINDEXES
                SYSINDEXES_HIST
                SYSINDEXPART
                SYSINDEXPART_hIST
                SYSINDEXSTATS
                SYSINDEXSTATS_HIST
                SYSJARCLASS_SOURCE
                SYSJARCONTENTS
                SYSJARDATA
                SYSJAROBJECTS
                SYSKEYCOLUSE
                SYSKEYS
                SYSLINKS
                SYSLOBSTATS
                SYSLOBSTATS_HIST
                SYSPACKAGE
                SYSPACKAUTH
                SYSPACKDEP
                SYSPACKLIST
                SYSPACKSTMT
                SYSPARMS
                SYSPKSYSTEM
                SYSPLANDEP
                SYSPLSYSTEM
                SYSPROCEDURES
                SYSRELS
                SYSRESAUTH
                SYSROUTINEAUTH
                SYSROUTINES
                SYSROUTINES_OPTS
                SYSROUTINES_SRC
                SYSSEQUENCEAUTH
                SYSSEQUENCES
                SYSSEQUENCESDEP
                SYSSTMT
                SYSSTOGROUP
                SYSSTRINGS
                SYSSYNONYMS
                SYSTABAUTH
                SYSTABCONST
                SYSTABLEPART
                SYSTABLEPART_HIST
                SYSTABLES
                SYSTABLES_HIST
                SYSTABLESPACE
                SYSTABSTATS
                SYSTABSTATS_HIST
                SYSTRIGGERS
                SYSUSERAUTH
                SYSVIEWDEP
                SYSVIEWS
                SYSVLTREE
                SYSVOLUMES
                SYSVTREE
                USERNAMES
        DB2 Directory
                DBD01
                SCT02
                SPT01
                SYSLGRNX
                SYSUTILX
       dependent
                referential constraints
        drops
        DSN FUNCTION TABLE 2nd
                columns
                creating
                RUNSTATS
                version 8
        DSN STATEMENT TABLE 2nd
                columns 2nd 3rd
                columns;APPLNAME
                columns;COLLID
                columns;COST CATEGORY
                columns;EXPLAIN TIME
                columns; GROUP MEMBER
                columns;PROCMS
                columns;PROCSU
                columns;PROGNAME
                columns;QUERYNO
                columns;REASON
                columns;STMT ENCODE
                columns;STMT TYPE
                creating
                RUNSTATS
                version 8
        DSN_FUNCTION_TABLE 2nd 3rd
                columns 2nd
        DTD repository 2nd
        dummy
       empty
                rows, adding
        emptying
        encoding schemes
       exception
                defining
        function
        IN DATABASE clause
        indexing
       INDEXSPACESTATS
                columns 2nd 3rd
        inner
       ISPF
                TSO 2nd
       join
                4GL applications
        join limitations 2nd 3rd
        joining 2nd 3rd 4th 5th
                criteria
                INNER keyword
                JOIN keyword
                table joins
                three-table
       large
                indexing
       loading
                indexes
        LOB columns, creating 2nd 3rd
                auxiliary tables
                defining
                example 2nd
                LOB table spaces
                populating
                unique indexes
        LOBs
        locks 2nd 3rd
        logs, augmenting
        materialized query
                navigational queries
        materialized query.
       mirror
                binding
                denormalization
                package support
        MQTs
       multiple
                partitioned table spaces, compared 2nd 3rd 4th 5th
        names 2nd
        navigational queries
        normalized
        OBIDs, specifying
        outer
        parameters
                AUDIT ALL
                AUDIT CHANGES
                AUDIT NONE
                CCSID
                DATA CAPTURE
                DROP
                OBID
       parent
                referential constraints
        partition key ranges
        pivoting
       PLAN TABLE
                optimization hints
        PLAN TABLE.
        PLAN_TABLE columns 2nd
       pre-joined
                denormalization
        Q.RESOURCE_TABLE 2nd
       reference
                multi-table table spaces
       report
                denormalization
        rows 2nd
                abbreviation standards
                data types 2nd
                data types, slecting 2nd 3rd
                date/time data
                date/time stamp 2nd
                defaults 2nd
                duplicate
                keeping
                navigational queries
                nulls 2nd 3rd 4th
                primary keys
                ROWID data types
                sequence objects 2nd 3rd 4th
                sequencing 2nd
                surrogate keys
                wasted space
        RTS 2nd 3rd 4th
                INDEXSPACESTATS columns 2nd 3rd
                TABLESPACESTATS columns 2nd 3rd
       sample
                activity 2nd
                department 2nd
                employee 2nd
                employee assignment
                employee photo & resume 2nd
                project 2nd
                project activity 2nd
                storage group
                views 2nd 3rd
        schemas, duplicating
        security
        skeleton cursor.
       small
                indexing
        snapshot 2nd
       snapshots
                data warehouses, populating
       space
                column data type changes
       spaces
                adding partitions 2nd
                boundaries
                partitioning 2nd 3rd 4th
                rebalancing partitions 2nd
                rotating partitions 2nd
       speed
                hierarchies 2nd
       split
                base table views 2nd
                denormalization 2nd
        statement
        SYSCOLDIST 2nd
        SYSCOLDISTSTATS
        SYSCOLSTATS
        SYSCOLUMNS 2nd
        SYSIBM.SYSCOPY
                ICTYPE column
       SYSIBM.SYSDUMMY1
                access
       SYSIBM.SYSPSM
                SQL stored procedures, creating
       SYSIBM.SYSPSMOPTS
                SQL stored procedures, creating 2nd
        SYSINDEXES 2nd
        SYSINDEXPART 2nd
        SYSINDEXSTATS
        SYSLOBSTATS
        SYSROUTINES 2nd
        SYSTABLEPART
        SYSTABLES 2nd
        SYSTABLESPACE 2nd
        SYSTABSTATS 2nd
       TABLESPACESTATS
                columns 2nd 3rd
        temporary
                created 2nd 3rd
                declared 2nd 3rd 4th 5th 6th 7th 8th 9th
                functions 2nd
                host variable lists
                names
                navigational queries
                non-relational data
                stored procedures 2nd
       triggers
                LOAD utility
                navigational queries 2nd
        XML administration support 2nd
                backing up
                DTD repository table 2nd
                XML usage table 2nd
        XML usage 2nd
TABLESPACE DB2 object
tablespace scans 2nd
tablespaces
       DASD
                monitoring
       DB2 Catalog
                separating
        image copies
        information statistics
       partitioned
                data sharing group buffer pools
        physical characteristics
        physical statistics query
       reorganizing
                RTS
        RUNSTATS, running
        scan queries
TABLESPACESET parameter
        QUIESCE utility
TABLESPACESTATS table
        columns 2nd 3rd
TABNO column
        PLAN TABLE
TAN function
TANH function
tape options
        TEMPLATE statement
TASKREQ ENTRY macro parameter
TASKREQ POOL macro parameter
tasks
        CICS
        Procedural tasks 2nd
        UDFs
TCBLIMIT parameter
        DB2CONN parameter
TCBs
        maximum
TCP/IP
        distributed connections
TCP/IP networks
        member routing
technical environment
        CASE tools support
technical issues
        Procedural DBA 2nd
technical support
teleprocessing environment
        tuning 2nd
teleprocessing environments
        tuning
TEMPLATE control statement
        utilities
TEMPLATE statement
        data sets, allocating 2nd
        disk options 2nd
        examples 2nd
        names
        options 2nd
                BUFNO
                DATACLAS
                DISP
                DSN
                EXPDL
                GDGLIMIT
                MGMTCLAS
                MODELDCB
                RETPD
                STORCLAS
                UNIT
                VOLCNT
                VOLUMES
        symbolics 2nd
        tape options
TEMPLATE statements
        database object lists
templates 2nd
        disk options 2nd
        examples 2nd
        names
        options 2nd
        tape options
        testing 2nd
        UDFs
temporary tables
        advantages
        created 2nd
        declared 2nd 3rd
                advantages 2nd
                scrollable cursors
                storage 2nd
                Version 7 enhancements 2nd
        functions 2nd
        host variable lists
        names
        navigational queries
        non-relational data
        stored procedures 2nd
TERM command
        utilities, monitoring
TERM UTILITY command 2nd
Terminal Monitor Program.
terminating
        DSN command sessions
        MODIFY STATISTICS utility
        UNLOAD utility
        utilities 2nd
testing
        database object lists 2nd
        denormalization validity
        disaster recovery plan
        existence 2nd
        expression equality
       system
                CASE tools support
        templates 2nd
        trigger logic
testing pools
        IMS
third normal form
third-party solutions
        compression 2nd
third-party utilities
third-party vendors
THRDA COMD macro parameter
THRDA parameter
THRDM COMD macro parameter
THRDM ENTRY macro parameter
THRDM parameter
THRDM POOL macro parameter
THRDMAX RCT INIT macro parameter
THRDS COMD macro parameter
THRDS ENTRY macro parameter
THRDS POOL macro parameter
thread operation attributes
        DB2ENTRY parameter 2nd
thread selection attributes
        DB2ENTRY parameter
THREADLIMIT parameter
        CICS pool thread attributes
        CICS thread operation attributes
threads
        CAF 2nd
        CICS 2nd
       common
                CICS
       distributed
                DB2 Connect 2nd
       distributed processing
                connection pools 2nd
                inactive DBATs 2nd
       entry
                CICS
        IMS 2nd
        in-doubt
       inactive
                connection pools 2nd
       pool
                CICS 2nd 3rd
       pooling
                DB2 Connect EE 2nd
       protected
                transactions
        types 2nd
THREADWAIT parameter
        CICS pool thread attributes
        CICS thread operation attributes
three-level indexes
        pages
three-part names
        system-directed distribution 2nd
three-partition table space example 2nd 3rd
three- tier environments
        Net.Data support
three-valued logic.
thresholds
        buffer pools 2nd
        data sharing group buffer pools
throughput 2nd 3rd
        availability
        buffer pool size
        contention
        hardware
throughput chains
Thumbnail UDF
        image
TicksPerQNote UDF
        audio
TicksPerSec UDF
        audio
TIME data type 2nd 3rd
        promotability
TIME durations
TIME function
Time-Sharing Option.
time/date data
        tables
time/date stamps
        tables 2nd
timeout errors
timeout messages
timeouts
       lock
                minimizing
        locks
TIMESTAMP column
        PLAN TABLE
TIMESTAMP data type 2nd 3rd
        promotability
TIMESTAMP durations
TIMESTAMP function
TIMESTAMP_FORMAT function
timestamps
        interpreting
        online applications
        rounding/truncating
timouts
       tuning
                DSNZPARMs 2nd
TMP (Terminal Monitor Program)
TNAME column
        PLAN TABLE
TOKENE ENTRY macro parameter
TOKENI RCT INIT macro parameter
tokens
       explicit consistency
                BIND statements
Tone Software Corp.
tools
       add-on
                auditing 2nd 3rd
                Catalog query and analysis 2nd
                categories 2nd 3rd
                client/server
                compression 2nd
                DASD and space management
                data movement 2nd
                database analysis 2nd
                database modeling and design 2nd
                integrity 2nd
                Internet enabling
                miscellaneous
                object migration
                operational support 2nd
                PC-based
                performance enhancement
                performance monitors 2nd
                plan analysis 2nd
                programming and development
                QMF enhancement
                query 2nd 3rd
                repositories 2nd
                security 2nd
                table altering 2nd 3rd
                table editors 2nd
                utility enhancement
       analysis
                SQL statements
       CASE
                application development 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th
       DBA
                Version 7 enhancements
       debugging
                CICS
        EXPLAIN feature
       internal DBA
                stored procedures
        report writers 2nd
                capabilities
        required
        SQL Assist
       vendor
                CAF
        vendor guide
       vendors
                evaluating 2nd 3rd
Top Ten retrieval 2nd
TOTALENTRIES column
        INDEXSPACESTATS table
TOTALROWS column
        TABLESPACESTATS table
TRACE (/ before) command
trace destinations
        specifying
Trace Record Distribution report
TRACEID RCT INIT macro parameter
traces 2nd
        accounting 2nd 3rd 4th
        accounting trace reports
        audit 2nd 3rd 4th
        basic statistics, collecting
        DB2 PM reports, starting 2nd 3rd
        destinations 2nd
        global 2nd 3rd
        IFCIDs
        monitor 2nd 3rd 4th
        performance 2nd 3rd 4th
        starting
        statistics 2nd
       tuning
                DSNZPARMs
tracking
        modified pages (table spaces)
TRACKMOD parameter
        table spaces
traffic
       network
                DB2 Internet applications
training
        4GL applications
        EXPLAIN feature
        Net.Data macro language
transaction locks
        claims/drains, compared
transaction recovery
transactions
        CICS
        divertable
       grouping
                CICS
        monitoring
        online applications
        protected threads
        queues, tuning
       read-only
                IMS SYSGEN
        WFI
TRANSID parameter
        CICS thread selection attributes
transit time report sets 2nd 3rd
Transit Time Summary report
transition variables
        triggers 2nd 3rd
TRANSLATE function
        UPPER function, compared
translating
        authids 2nd
                consistent authids
                network specific authids
                password encryption
trasit time report sets
Treehouse Software
trees
        syncpoint
triggers
        after 2nd
        before 2nd 3rd
        benefits 2nd 3rd
        check constraints, compared 2nd
        client/server applications
        creating 2nd 3rd 4th 5th 6th
                activation
                events, selecting
                examples 2nd 3rd
                granularity
                logic
                SQL statements
                tables, defining
                transition variables 2nd
                WHEN clause
        data integrity
        data warehouses 2nd
        declarative referntial integrity
        firing 2nd 3rd
        granularity
        implementing 2nd
        limitations
        logic, testing
        multiple 2nd
        names 2nd
        navigational queries 2nd
        nesting 2nd
        non-DB2 resources, accessing
        packages 2nd
        performance
        Procedural DBA
        referntial integrity 2nd 3rd
        row-level
        simplicity
        statement-level
        stored procedures, compared
        storing
       tables
                LOAD utility
        transition variables
        VALUES statement
troubleshooting
        data warehouses
        DPSIs 2nd
        performance 2nd 3rd 4th
TRTCH option
        TEMPLATE statement
TRUNC function
TRUNC_TIMESTAMP function
TRUNCATE function
truncating
        timestamps
TSLOCKMODE column
        PLAN TABLE
TSO 2nd
        Attachment Facility
        batch applications 2nd 3rd 4th
        commits
        DB2-PM
        DB2I 2nd
                bind option
                DB2 Commands option
                DCLGEN option
                Defaults option
                Free Plan option
                menu
                precompile option
                Program Preparation option
                rebind option
                Run option
                SPUFI option 2nd 3rd 4th 5th
                Utilities option
        functionality/efficiency
        ISPF panels
        ISPF tables 2nd
        MVS performance groups
        online applications
                binding
                design 2nd 3rd 4th 5th
                DSN command processor 2nd
        parameters 2nd
        QMF 2nd 3rd
                Form panel
                Home panel
                Proc panel
                Query panel
                Report panel
                sessions
        resources, integrating
        TMP
TSO (Time-Sharing Option)
TSO commands
tuning
       active users
                DSNZPARMs
        applications 2nd 3rd
                access paths 2nd 3rd 4th 5th
                nonuniform distribution statistics, deleting 2nd
                optimizer, influencing.
                referential integrity 2nd 3rd
        buffer pool parameters 2nd
                DWQT
                PGSTEAL
                VDWQT
                VPSEQT 2nd 3rd 4th 5th 6th
                VPSIZE
                VTYPE
        buffer pool size 2nd 3rd
        buffer pools 2nd 3rd 4th 5th
                access, isolating
                active buffer pools, converting
                allocation 2nd
                allocations
                available pages
                BP0 optimization
                BP0, monitoring
                BP32
                BP32K
                BP32K, allocating
                example scenario 2nd
                multiple buffer pools 2nd
                one large buffer pool 2nd
                performance
                processing 2nd
                reserving
                reserving buffer pools
                sort buffer pools
                stealing
                tables, isolating
                thresholds 2nd
                unavailable pages
        CPUs 2nd 3rd 4th 5th
        data sharing group buffer pools 2nd 3rd 4th 5th
                castout process
                duplexing
                GBPCACHE parameter
                partitioned tablespaces
                size
                thresholds
        database design 2nd 3rd
        database designs
        DB2 Catalog 2nd 3rd 4th
                contention 2nd 3rd
                data set placement 2nd
                data sets
                indexes 2nd
                performance
                reorganizing
                RUNSTATS
                size
                SQL access, monitoring
                tablespaces, separating
                timeouts/deadlocks
        DSNZPARMs
                active users
                EDM pools
                locks
                logs 2nd
                timeouts 2nd
                traces
        dynamic SQL
       EDM pools
                DSNZPARMs
        hierarchy
        hiperpool parameters 2nd
        hiperpools 2nd 3rd
        I/O 2nd 3rd
                application 2nd 3rd
                costs, minimizing
                DB2 Catalog
                disk device retrieval costs
                internal 2nd
                log 2nd 3rd 4th
                page retrieval
                paging 2nd 3rd
                RAMAC
                sort 2nd
                write operations
        IRLM address space 2nd
       locks
                DSNZPARMs
       logs
                DSNZPARMs 2nd
        memory 2nd
                buffer pools 2nd
                DB2 code
                EDM pools 2nd 3rd 4th 5th
                IRLM 2nd 3rd
                memory requirements
                open data sets 2nd 3rd
                RID pools 2nd
                sort pools 2nd
                working storage
                z/OS 2nd
        operating systems
        OS/390
        referential integrity 2nd 3rd 4th
        shared data
        subsystem
        teleprocessing environments 2nd 3rd
       timeouts
                DSNZPARMs 2nd
       traces
                DSNZPARMs
        transaction queues
        z/OS 2nd 3rd 4th 5th 6th
turnovers
        procedures
TWAIT COMD macro parameter
TWAIT ENTRY macro parameter
TWAIT POOL macro parameter
TWAITI RCT INIT macro parameter
tweaking
       SQL statements
                optimizer, influencing 2nd 3rd
two-level indexes
        pages
two-phase commit distribution
        actual commit 2nd
        multi-site updates
        one-phase, compared
        preparation phase
        syncpoint trees
two-phase commits
        CICS 2nd
        IMS 2nd 3rd
two-tier environments
        Net.Data support
two-valued logic.
TXID ENTRY macro parameter
TXIDSO RCT INIT macro parameter
Type 1 indexes
        pages
        Version 6 2nd
type 1 leaf index data pages 2nd 3rd
type 1 non-leaf index data pages
Type 2 indexes
        organizing
        pages 2nd 3rd
        storage 2nd 3rd
        Version 6
type-2 connections
types
        denormalization
                combined tables
                derivable data
                hierarchies 2nd 3rd 4th
                large page sizes
                mirror tables
                pre-joined tables
                redundant data
                repeating groups 2nd
                report tables
                split tables 2nd
        table spaces
                partitioned 2nd 3rd
                partitioned.
                segmented 2nd
                simple 2nd