HomeНаука и техникаRelated VideosMore From: Tech Query Pond

Oracle SQL Tutorial : Using execution plan to optimize query in oracle

96 ratings | 17523 views
Oracle SQL Tutorial Oracle tutorial: Explain plan for query optimization in Oracle PLSQL Performance tuning explain plan in oracle performance tuning in oracle oracle tutorial for beginners explain plan in oracle 11g using execution plan to optimize query sql query analyzer sql query cost analysis https://techquerypond.wordpress.com This oracle tutorial show you how to use EXPLAIN PLAN in oracle. This video covers how to check cost of the query from DBMS_XPLAN.DISPLAY . You can find the cost of the query using the Using EXPLAIN PLAN FOR and based on the result you can optimize the query for faster performance. Subscribe on youtube: https://www.youtube.com/channel/UCpiyAesWNYOXSz5GPq8lbkA For more tutorial please visit #techquerypond https://twitter.com/techquerypond
Html code for embedding videos on your blog
Text Comments (8)
Andreas Neumann (4 months ago)
Great video! As for a tool for query optimization, I can suggest dbForge Studio for Oracle - https://www.devart.com/dbforge/oracle/studio/
Sid (4 months ago)
Chetan Khairnar (6 months ago)
I got to know about explain plan, what about complex queries?? and is indexing the only way to reduce cost???
md javeed (6 months ago)
Nice explaination
Shikha Acholia (9 months ago)
thanks for ur efforts. Want to know what is meant by % CPU usage. Is that the CPU of the machine or what is it talking about
Tech Query Pond (9 months ago)
CUP usage of the machine
Ravindra Pratap (1 year ago)
Nicely explain....appriciated
Tech Query Pond (1 year ago)
Thanks Ravindra Pratap

Would you like to comment?

Join YouTube for a free account, or sign in if you are already a member.