Bind Variables and Partition Elimination

Hi all

I am trying to find some solid background information on using bind variables and partition elimination. The sparse information I found by querying the web is confusing me.

Some informations seem to indicate that partition elimination does not occur with the use of bind variables while others state the oposite.

For example on
http://www.ixora.com.au/tips/design/partitioning.htm the author writes:

"Partition Elimination
Another benefit of range partitioning, is automatic partition elimination during the formulation of query execution plans. The optimizer compares the WHERE clause predicates with the partitioning range for each partition and eliminates from the execution plan those partitions which can be guaranteed not to contain rows satisfying the query. Of course, partition elimination normally relies on not using bind variables, so that the optimizer can determine which partitions can be eliminated. However, in the case of equality predicates on the partitioning key, the optimizer is content in the knowledge that at most one partition will be required"

Can someone shed some light on this issue ?

With best regards

Martin Pammer
VRZ Informatik
Dornbirn
Austria
m p a m m e r <at> v r z . n e t Received on Thu Feb 14 2002 - 04:37:42 CST