Case-Insensitive Search in SQL - Use The Index, Luke!

13 Mar 2012 ... Ignoring the case in a where clause is very simple. ... The logic of this query is perfectly reasonable but the execution plan is not: Oracle ... In reality the optimizer's view is more like this:.

use-the-index-luke.com