Reply from mkkumar76 on May 27 at 7:55 PM Hi Shivasson,
Create a function-based index on UPPER(Name) column,
then performance of the query will be better.
MK Kumar
| | | ---------------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. __.____._ | In the Spotlight Become a blogger at Toolbox.com and share your expertise with the community. Start today.   _.____.__ |
No comments:
Post a Comment