Function in predicate produces different execution plan

Author: asktom.oracle.com | Published: 13th Dec 2007 | Visited: 104 times | Add Comment
Filed in: Oracle FAQ

Hi Tom Greetings from the great state of Indiana home of the Indiana Oracle Users Group (INOUG), you need to come back and visit. DB Version: 9.2.0.4 on UNIX I have a simple query that uses what turns out to be a constant on the right side o...

Read Article

Sponsored Links

• Article :: Getting Your Disaster Recovery Plan Funded - with an Awesome Business Impact Analysis, Pa... Why won't management fund your disaster recovery plan? It's time to revise your think ...

• How to call Server Side function from Client Side Code using PageMethods in ASP.NET AJAX How to call Server Side function from Client Side Code using PageMethods in ASP.NET ...

• Clean Up Function Syntax Mess with decltype The funky syntax of a function's return type isn't just unreadable in many cases—it's also a common source of maintenance problems. However, with the new decltype operator your functions will look much cleaner and easier to maint ...

• CreateCheckboxImageList - a non-MFC function to create an imagelist of themed checkboxes CreateCheckboxImageList is a function that creates an imagelist of themed or non-themed checkboxes, suitable for use in tree controls, list controls, and list bo ...

• EnableGroupboxControls - a non-MFC function to enable or disable all the controls within a groupbox EnableGroupboxControls is a function that enables or disables all the controls within a groupbox based solely upon the window rect of the controls. A simple approach to implementing a groupbox checkbox is also explai ...

• Refactoring a Function to Become a Bound Function In this series of blogs, Sun's Mike Heinrichs tells you how to use the JavaFX Script programming language. This latest blog describes bound functi ...

• How to Bind DropDown List in DetailsView Controls without using DataBind Function to fix problem of using DataBind() Function in detailsView Con ...

• How to query miniport driver information (802.11 OIDs) using DeviceIOControl() function? Query 802.11 OIDs using DeviceIOControl from a .NET-C# applica ...

• Kidaro Buy Latest in Microsoft's Virtualization Plan Microsoft is buying desktop virtualization software maker Kidaro in a move to incorporate the smaller firm's technology into a key enterprise tool su ...

• Article :: An Integrated Certification Plan Warren Wyrostek discusses why the Master of Integrated Networking could breathe new life into the certification mar ...

Next: Index range scan