Queries use is_deleted <> 'Y' but is_deleted = 'N' might support better execution plans

[punktilious]

Describe the bug
JDBC queries use is_deleted <> 'Y' to filter out resources which have been marked as deleted. Although only one row needs to be logically checked (the current resource), the optimizer might try to access this first and therefore require scan multiple rows when only one will match. Using is_deleted = 'N' is a better strategy should there be a suitable index available.

[lmsurpre]

I confirmed that there's no more refrences to 'Y' in our jdbc project and that the queries continue to work as expected