Constraint Optimization: The Difference A Comma Can Make
-
Posted by Quest Customer Learning Team
- Last updated 4/13/21
- Share
Presented at INSYNC 21
Session ID: 101610
A task can be done in a very short way and in a very long way. Which one will you choose? Knowledge is Power! This session gives lots of interesting knowledge about an allegedly boring topic – Constraints. And this knowledge will give you the power to optimize and make better decisions.
The behavior of adding columns and constraints to big tables in Oracle may vary significantly, in two aspects – duration and availability – based on the way we perform these operations. In addition, different constraints may have different impact, based on their syntax, types, states, locking, etc.
Attend this session to understand what happens exactly under the hood when we issue a simple ALTER TABLE statement, and how to utilize this knowledge for achieving better performance or higher availability.
Watch the full-length video
You’ve reached the ultimate Oracle customer network—exclusively for Quest Corporate and Professional members.
Join Quest to unlock access to strategic content centers, event replays, exclusive programming, and expert insights—all designed to help Oracle users like you go further, faster.
Whether you're on JD Edwards, PeopleSoft, or Oracle Cloud, Quest connects you with a powerful peer network and Oracle experts so you can make smarter decisions, drive innovation, and get more from your investment.
Quest is where Oracle customers connect, learn, and lead with confidence. Ready to join them?
