sql tuning using execution plan

Author: asktom.oracle.com | Published: 8th Feb 2008 | Visited: 70 times | Add Comment
Filed in: Oracle FAQ

Hi Tom, My Client complaints me that this particular query taking lots of time. initially it was working well. i tried to tune from my side but in vain i need a expert advice on this. please tom help me out in tuning this query. i will be very tha...

Read Article

Sponsored Links

• Article :: Getting Your Disaster Recovery Plan Funded - with an Awesome Business Impact Analysis, Pa... Why won't management fund your disaster recovery plan? It's time to revise your think ...

• Tuning sql with bind variables Hi Tom, Here is a sample sql from a package used for searching clients. The query is very fast when we remove the "OR" condition "ln_cl_id is null" from the WHERE condition. There are many columns with similiar OR condition, which I have remove ...

• Tuning Tips Dear Mr.Kyte, Greetings Can you please give me some guidelines of how to tune these topics: 1)db file scattered read, db file sequential read. 2)hot data files reading (Hot blocks), physical read and logical read. 4)high CPU Time. 3) and ...

• Kidaro Buy Latest in Microsoft's Virtualization Plan Microsoft is buying desktop virtualization software maker Kidaro in a move to incorporate the smaller firm's technology into a key enterprise tool su ...

• Article :: An Integrated Certification Plan Warren Wyrostek discusses why the Master of Integrated Networking could breathe new life into the certification mar ...

• 4GT RAM Tuning 4GT is mechanism that expands applications virtual address from 2048 (2 GB) up to 3072 (3 ...

• Jeff Barr Has A Plan... Jeff Barr’s Blog � Save the Rovers! Apparently NASA plans to cut one of the two Mars Rovers from it's budget. But Jeff Barr has a plan to help save it... The second plan is a bit different. What i ...

• Tips for tuning ActionScript 3.0 performance for Flex and Flash developers Learn about the Flash Player architecture and AVM2, and improve performance through typing and data binding in your Flex and Flash application developm ...

• MySQL InnoDB Performance Tuning for the Solaris 10 OS You can maximize the performance of MySQL on the Solaris platform through configuration and tuning of the database server, along with optimizing the Solaris OS for My ...

• DirectShow: TV Fine-tuning using IKsPropertySet in C# Enhancements to the DirectX.Capture class for TV fine-tuning using IKsPropert ...

Next: Partition name in Result set?