Upload

Loading icon Loading...

This video is unavailable.

Best Practices for Developing Optimally Performing SQL with Karen Morton

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to like Embarcadero Technologies's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to dislike Embarcadero Technologies's video.

Sign in to YouTube

Sign in with your Google Account (YouTube, Google+, Gmail, Orkut, Picasa, or Chrome) to add Embarcadero Technologies's video to your playlist.

Published on Apr 5, 2012

Learn more about DB PowerStudio for Oracle at http://www.embarcadero.com/products/d...

Learn from OakTable Network Member and Oracle ACE Karen Morton as she lets you in on her best practices for developing optimally performing SQL.

Karen will reveal the importance of planning first, what key questions to ask during the process, and using "what if" analysis to ensure your code is performing its best. Attendees of this Oracle Community Webinar will take away best practices such as:

Plan first - There's almost always more than one way to write a SQL statement. Cover your bases.
Ask questions - You have to "tune the question, not the query". The more questions you ask, the deeper your understanding.
Focus on the journey, not the destination - If you are only focused on what the query answer/result is, you'll likely overlook how you write SQL. Typically, how and why are more important questions to ask.
Gather data - You have to know/understand the resource consumption of your SQL in order to know if it will perform well (both short and long term).
Play "what if" - Try to determine what would happen if certain conditions occurred. Things like data volume increase and number of users can have an effect on how your query will perform. "What if" games will help you think about scalability.
Instrument your code - Add a way to monitor and trace your code easily on demand.
TTT (Test To Destruction) - Test, test, test....then test some more!

Loading icon Loading...

Loading icon Loading...

Loading icon Loading...

The interactive transcript could not be loaded.

Loading icon Loading...

Loading icon Loading...

Ratings have been disabled for this video.
Rating is available when the video has been rented.
This feature is not available right now. Please try again later.

Loading icon Loading...

Loading...
Working...
Sign in to add this to Watch Later

Add to