Dear All,
Good day!!
In one of our prod db, the high consuming SQL's are consist of trim function. It's llike, .... where trim(id)=trim(user_id)/ id=trim(id); due to this , it's very frequent to observe full table scan.
How can we avoid trim function in such condition/alternative to trim?? Is it obvious full table scan when we use trim function??
Thanks in advance...