HomeОбразованиеRelated VideosMore From: anilkumar ghorakavi

[Oracle SQL Performance Tuning: 1/4] Overview of SQL Processing

0 ratings | 7730 views
The series of SQL tuning videos presents performance tuning tips for developers. For presentation used in this video, please visit: https://drive.google.com/drive/folders/0B6EDqGZwjejmWng5VWM3ZEtaNzA?usp=sharing
Html code for embedding videos on your blog
Text Comments (37)
vivek rao Chavhan (2 months ago)
According to your video, In sql query overview slide :-Employee table must be writeen first then join with department table However u write department table first....? Pls correct me if i' m wrong
anilkumar ghorakavi (1 month ago)
No ideally when you are writing the query as a developer, even though you need data from employee table your query is driven by the department name. So I will start with the department in the query and that should be the right execution path as well in most of the cases.
Sunil bsr3 (5 months ago)
Please share PPT for performance tuning
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
abhinay reddy (7 months ago)
Hi Can you please share the PPT mail id : [email protected] Thanks in Advance.
karthi c (8 months ago)
sir can u share the ppt
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
Ravinder Reddy Guduru (11 months ago)
Very clear explanation ! thanks for sharing this video
financial buildups (1 year ago)
very Useful , please send me a ppt
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
Edukondalu Muchumuri (1 year ago)
helpful information.............
Shilpa V (1 year ago)
Volume is too low very difficult to listen please make sure volume of the video is more
anilkumar ghorakavi (1 month ago)
Sure, will try if I can edit this.
Srikanth goud (1 year ago)
Thank you for making it very simple to understand Join Methods..
Prabhath chalasani (1 year ago)
Very nice presentation anil... can u plz share all the 4 presentations Mail id: [email protected]
Motilal Daravatu (1 year ago)
Nice video, Please share the presentation
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
Sri Harsha (1 year ago)
Hi anil, very nice session. Can you please send me the ppt that was presented in all 4 sessions please.
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
uday jampani (1 year ago)
Very useful!
uday jampani (1 year ago)
@22:35 do you mean if order by is there in the full query ; optimizer priorites sort merge join over hash join in the larger interest of query
anilkumar ghorakavi (1 year ago)
Logically yes. But in performance world things are mostly contextual. Depends on how optimizer sees your data or understands your data. Just to summarize: a) when the join condition is inequality or b) if sorting is anyways required (due to order by clause or any hint) sort-merge join is preferred to hash join when dealing with larger data sets.
Kiranjit Parida (2 years ago)
Hi Please can you share me the PPT used in this vedio.
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
Rahul Soni (2 months ago)
+anilkumar ghorakavi Please share all the ppt to me as well at [email protected]
KIRANJIT PARIDA (2 years ago)
Thank You very much Anil.
anilkumar ghorakavi (2 years ago)
Message me your email ID. Thanks.
Bharath Kumar (2 years ago)
Thank you so much for uploading such a informative video.
ashis mohanty (2 years ago)
Crystal clear understanding......share the ppt please....
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
anilkumar ghorakavi (2 years ago)
Thanks Ashis. Please send me an email or share your email for ppt.
Zareena Sikander (2 years ago)
Can you share ppt ?
anilkumar ghorakavi (1 month ago)
Added in the video description. Please check.
anilkumar ghorakavi (2 years ago)
Please send me an email or share your email.
Zareena Sikander (2 years ago)
Please send the PPT used in video. Thanks
anilkumar ghorakavi (2 years ago)
+Zareena Sikander Sure
pratap kumar (2 years ago)
very nice explanation. Thank you!!

Would you like to comment?

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