Reply from SteveFLHSMV on May 27 at 3:06 PM Using a view to perform the upper function will not improve performance. You may want to consider a function based index. They have been available since 8i. Since you probably want a composite index on ID, UPPER (Name) and UPPER(Description), altering your table to add virtual columns for UPPER(Name) and UPPER(Description) might be a better option if you are using 11g.
| | | ---------------Original Message--------------- From: Shivas san Sent: Sunday, May 27, 2012 10:03 AM Subject: Oracle View - Performance Tuning 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