http://qs1969.pair.com?node_id=307253


in reply to Re: Re: Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE
in thread Use Placeholders. For SECURITY and (sometimes) for PERFORMANCE

In Oracle 
analyze table <table name> compute statistics for all indexed columns 
+size 254;

[download]
with generate a histogram of weightings for each range of values that are in the indexed columns. Parse trees can be generated on a case by case basis. In the latest versions you can "fake" the stats to get the optimizer to behave properly.

rdfield

In Section Meditations