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

How to Tune Oracle SQL - Lesson 4 - Understanding The Bind Step

1 ratings | 781 views
Learn how to tune Oracle Database SQL! In this lesson you will learn that before SQL can be executed it must be parsed and part of the parse process is "bind". Learn what bind variables are, how variables impact SQL, why they are so important, when to use them and when not to use them. Writing SQL that performs well means understanding what Oracle is doing to the SQL: how it is executing the code, and why it is executing it that way. Then make changes needed to let Oracle run the code in a more efficient manner.
Html code for embedding videos on your blog
Text Comments (0)

Would you like to comment?

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