We've a NVS RPTBOOK that keeps going out to lunch on PS_LEDGER with a Cartesian Join. We're using PeopleSoft Financials 9 and I've tried to tweak the performance any way I can and cannot get this query to come back. The NVS RptBooks use templates where you specify the criteria so the underlying query can't be rewritten. We're running CHOOSE with Oracle 10.2.0.3. Anyone come across anything like this before? Here's the query: SELECT l1.tree_node_num, l2.tree_node_num, SUM (a.posted_total_amt) FROM PS_LEDGER a, PSTREESELECT10 l1, PSTREESELECT10 l2, PSTREESELECT05 l WHERE a.ledger = 'ACTUALS' AND a.fiscal_year = 2006 AND a.accounting_period BETWEEN 1 AND 12 AND l1.selector_num = 14422 AND a.deptid >= l1.range_from_10 AND a.deptid <= l1.range_to_10 AND ( l1.tree_node_num BETWEEN 1996093750 AND 1997802733 OR l1.tree_node_num BETWEEN 1998046875 AND 1999023436 OR l1.tree_node_num BETWEEN 1999267577 AND 1999389646 OR l1.tree_node_num BETWEEN 1999450682 AND 1999511717 ) AND l2.selector_num = 13780 AND a.ACCOUNT >= l2.range_from_10 AND a.ACCOUNT <= l2.range_to_10 AND ( l2.tree_node_num BETWEEN 1687500000 AND 1734374999 OR l2.tree_node_num BETWEEN 1750000000 AND 1874999999 ) AND l.selector_num = 13782 AND a.business_unit = l.range_from_05 AND l.tree_node_num BETWEEN 1750000000 AND 2000000000 AND a.currency_cd = 'USD' AND a.statistics_code = ' ' GROUP BY l1.tree_node_num, l2.tree_node_num Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office: 615-517-3355 Cell: 615-354-4799 Email: chris.taylor@xxxxxxxxxxxxxxx