TRIM(UPPER(ABC.HELLO) as HELLO1
Will there be any difference in performance ??
Thanks in Advance !!
I have seen in most of the SQLs having Type cast conversion from varchar to interger and date to integer while processing from staging to next layer..
Code looks like:
This impact CPU is in 4 digits everyday for retrieving the data from the table..
I am expecting a suggestion to avoid this type of data type conversion in the Joins and how optimizer will take this query for processing and overhead of this type of query?