This query is a complex query that was figure as one of top 5 on my AWR reports, the complexity of him is caused because is a Auto Join query (Hierarchical query) and the rows returned by query are a mix of columns from first resultset and second resultset.    Even being a partitioned table[…]