Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Olusesi Ibrahim Adebisi , Senior DBA and Technical Lead Database Projects , MTN Nigeria
Date de publication: 2016/06/09
Hammad Shuaib
par 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