Hi Nadya,
I did not read your original carefully enough, so I missed some of your points.
If the number of parameters and indexes is a concern, I suggest you go for second approach. Is the "_" meant to be a space character? Anyway, you can shorten the lcName expression:
lcName = padr("GREE",25) + padr("MAR",20) +padr("",1)
select ... from ... where cl_name + cf_name + cm_Initial = lcName
If you skip the middle name:
lcName = padr("GREE",25) + padr("MAR",20)
select ... from ... where cl_name + cf_name = lcName
In my tests, the LIKE operator was never optimized.
>>Hi Nadya,
>>
>>Your first select is fully optimized, no need to rewrite it in any way.
>
>Hi Tore,
>
>I wanted to reduce number of view parameters and the complexity of the view. I also wanted to minimize number of indexes. What do you think about an index on Middle Initial? I think, we don't need to have it at all. But you're basically suggesting, that I have to return to the previous version of the view?
>
>Thanks again.