In 10g Oracle introduced the MEMBER OFF statement. The following article shows how using this feature handling binding in-list may introduce performance degradiation. The article also show an example where the feature increase performance. Once again: There is very few universal rules regarding SQL tuning.
jcon.no: Oracle blog
“One bad programmer can easily create two new jobs a year.” – David Parnas
Post a Comment