Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 1162

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 726

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 727

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 728

Warning: Cannot modify header information - headers already sent by (output started at /home/content/12/8647612/html/index.php:3) in /home/content/12/8647612/html/includes/bootstrap.inc on line 729
PS Query - Need Dependency and Prunable examples | CompShack.com

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

1 reply [Last post]
Larry's picture
User offline. Last seen 3 years 48 weeks 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

Guest's picture
Guest
Re: PS Query - Need Dependency and Prunable examples

I agree completely with your comment regarding PeopleBooks. I cannot figure this out either