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

Oracle tutorial : Using execution plan to optimize query in oracle

66 ratings | 10928 views
Oracle tutorial: Explain plan for query optimization in Oracle PLSQL oracle tutorial for beginners 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 (6)
Chetan Khairnar (11 days ago)
I got to know about explain plan, what about complex queries?? and is indexing the only way to reduce cost???
md javeed (28 days ago)
Nice explaination
Shikha Acholia (3 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 (3 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.