Performance degrades dramatically after adding escape clause in 9i
939633May 24 2012 — edited May 25 2012We are running a select statement against a view. Millions of records: select all myview_name from myview where myview.name like 'Csdfad (%) ssfdadf' escape '\' and ...
When we take off the escape '\' we get a result in less than a second but takes almost 10 minutes if we have the escape '\' . By the way we do not see this every time we add an escape only in some cases. We see there is a massive increase in physical reads as well.
Any ideas about what could be causing this.