[oracle-db-l] Oracle View - Performance Tuning

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.   __.____._ Manage Settings | Unsubscribe | Create FAQ | Send Feedback    Copyright © 2012 Toolbox.com and message author. Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251

shivassan     View this online Ask a new question   In the Spotlight Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App _.____.__