Interested to Buy Any Domain ? << Click Here >> for more details...
How can we tune a sql query to optimize the performance of a database?
- 1 Answers
- 6 Views
- I also Faced
- E-Mail Answers
Answer / Robinder Singh Goyath
Tuning SQL queries involves several steps: indexing, join optimization, reducing data retrieved, using appropriate functions and operators, and so on. It's also important to understand and address the root causes of poor performance such as lock contention, CPU bottlenecks, or I/O issues.
| Is This Answer Correct ? | 0 Yes | 0 No |
Mention in rac what files should be created on shared storage?
What is a system tablespace and why do we need it?
What is the load balancing advisory?
What are the benefits of oracle rac?
Mention what are the tools provided in oracle enterprise manager?
What is the difference between restoring a database and recovering a database?
How can we identify the resources for which the sessions are waiting?
How can you determine what protocol is being used for interconnect traffic?
What is split brain syndrome in rac?
How can we use tkprof?
Mention what is the difference between single instance environment and rac environment?
How is clustered index different from non-clustered index?
Oracle General 
