Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

What oracle tool is the best for oracle database performance tuning and why?

user-image
Question added by Olusesi Ibrahim Adebisi , Senior DBA and Technical Lead Database Projects , MTN Nigeria
Date Posted: 2016/06/09
Hammad Shuaib
by Hammad Shuaib , Cloud Developer , Enterprise Developement Services Company Ltd.

I believe that best tool available is your knowledge of SQL and some proper structuring of query.

By knowledge of sql, I mean there are various functions like analytical functions and clauses like with clause that can improve your query. I suggest read as much SQL as you can so that you can discover new concepts for optmization in subjected language.

By restructuring query I mean, write your query such as that it performs minimal calculations at a time.

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.