Hi guys,
I have a query which is giving performance issue, taking long time to complete.
Oracle db version - 12c
Using Toad to execute queries.
My query is like
Select *
From some_table
Where column_name in (:name);
But when I provide value for bind variable during run time the query becomes,
Select *
From some_table
Where column_name in (N'abcd');
Above is the not actual query I am running, it is just the demo of what is happening with my big query.
Column data type is VARCHAR2 and not NVARCHAR.
Column has simple index on it and my guess is because of this N, the index is not getting used and hence the performance issue.
I search on net and can see few have got this type of problem but didn't find solution.
Also Google tells, N is national language character.
Any suggestions on this would be appreciated.