Question from shivassan on May 27 at 10:02 AM Hi, I have a table with 2 million records. This table has a column ID, Name and Description columns. My select statement on this table is with where clause condition using UPPER function on Name and Description column. So, this statement is taking quite a long time to execute. Can i create a simple view by selecting ID, UPPER (Name) and UPPER(Description) column and run a select statement using this view without using UPPER function on Name and Description column in my where clause condition. In such scenario, will oracle consider View's UPPER case of Name and Description column or not? Would request help from experts. Thank you.. Shivasson | Reply to this email to post your response. __.____._ | _.____.__ |
No comments:
Post a Comment