Hello,

I have some queries with this type of WHERE:
WHERE FK_KEY=COALESCE(:param,FK_KEY)

I read this type of WHERE in some posts before and it is working as I
expected on the results side, however it doesn't use indexes.
Is there a way to do this with index (get all records when :param is
null and the indexed ones when :param is set to some value)?


TIA
Radu