Missed out looping in community... On Wed, Aug 31, 2011 at 5:01 PM, Venkat Balaji <venkat.bal...@verse.in>wrote:
> Could you help us know the tables and columns on which Indexes are built ? > > Query is performing sorting based on key upper(column) and that is where i > believe the cost is high. > > The 'upper' function is used up in the where clause? > > Thanks > Venkat > > > On Wed, Aug 31, 2011 at 4:49 PM, Jayadevan M <jayadevan.maym...@ibsplc.com > > wrote: > >> Hello, >> >> > > >> > > Please run EXPLAIN ANALYZE on the query and post that, it's hard to >> say >> > > what's wrong from just the query plan, without knowing where the time >> is >> > > actually spent. >> > Here is the explain analyze >> > http://explain.depesz.com/s/MY1 >> >> Going through the url tells me that statistics may be off. I will try >> analyzing the tables. That should help? >> Regards, >> Jayadevan >> >> >> >> >> >> DISCLAIMER: >> >> "The information in this e-mail and any attachment is intended only for >> the person to whom it is addressed and may contain confidential and/or >> privileged material. If you have received this e-mail in error, kindly >> contact the sender and destroy all copies of the original communication. IBS >> makes no warranty, express or implied, nor guarantees the accuracy, adequacy >> or completeness of the information contained in this email or any attachment >> and is not liable for any errors, defects, omissions, viruses or for >> resultant loss or damage, if any, direct or indirect." >> >> >> >> >> >
