Hi I have a query which joins a partition table with some dimensions, when I look the execution plan I can see pstart and pstop shows KEY KEY so pruning is occuring. Is there a way to find out exactly what partitions are accessed? I tried using V$SQL_PLAN_STATISTICS_ALL but it shows KEY KEY as well Alex