I'm wondering what the cost is of doing either lower(propname) or lower(selectorname.*) when used with the SQL2 LIKE operator. Also, is lower() strictly needed with the LIKE operator?
My limited testing show about a 10% slowdown when using lower(propname), but it's just a very rudimentary test. I'd also expect different results with property and lucene indexes? -- -Tor
