You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

PS Query - Need Dependency and Prunable examples

No replies
Larry's picture
User offline. Last seen 5 weeks 15 hours ago. Offline
Joined: 03/18/2008
Posts: 19

So I'm in the midst of modifying this massive PS Query to add some new functionality. It runs quite a long time, and after our last Tools upgrade I notice the new Dependency tab in Query Manager. It shows each record that is part of the query, and has a Prunable? checkbox.

There is also an Add Field Dependency pushbutton which opens up a gride below.

Of course, the documentation which Oracle provides on this functionality is totally lacking any examples or even a good explanation. Is anyone familiar with this? How does the "Prunable?" flag work? How are the Field Dependencies used?

My query has 10 tables/views and a ton of criteria. Several of the tables are pretty big and I don't necessarily have all the criteria needs to restrict them down to the point where they can easily use an index. Maybe "Prunable?" will help? But I need a better understanding of what it's doing and under what conditions... Examples would be wonderful.

Can anyone help?

Larry

Post new comment

CAPTCHA
The question below is to prevent automated spam submissions.
5 + 4 =
Solve this simple math problem and enter the result. E.g. for 1+3, enter 4.