Hello Tom,
I have a query that is behaving differently when N is included or excluded as part of query. One takes longer than the other to execute and has table scans when i explain plan on the query.
The query is a simple query like
Select count(DOC_ID) from DOCUMENT where DOC_ID = 'XXXXX';
This query works as expected where as
Select count(DOC_ID) from DOCUMENT where DOC_ID = N'XXXXX';
causes table scans etc. Both query however give the same result.

What does N in front of where value mean and do to the query?
Thanks
Kumud