Understanding Tree Manager and Pivot Grid

Pivot Grid invokes tree manager API CTamTreeAccess::PVGWhereStringTokens by passing tree meta data. Tree Access Manager returns the appropriate SQL phrases (string tokens containing PSTREESELECT table number & additional Query Criteria) for the FROM and WHERE clauses. Pivot Grid then appends the Query Criteria to the existing Pivot Grid Query.

Pivot Grid Query further performs a join with PSTREESELECT & PSTREENODE tables to retrieve tree data.

Tree Select tables are frequently used by Pivot Grid for accessing Tree data. Substantial data change operations such as insert, update or delete, changes the data distribution in the table or the indexed view and makes the statistics irrelevant. This happens when the correct data distribution does not reflect on the correct column or index, which results in the slow execution of Pivot Grid Query.

To make the pivot grid models load faster with multiple trees or deep trees, PeopleTools has:

• Updated tree selector table statistics.

• Added indexes.

• Used dynamic selectors.