When optimizing an update statement, does SQL Optimizer perform an update then a rollback? How does it simulate and optimize DML statements? Does the SQL Optimizer run SQL dynamically to give the run time / execution tuning result, e.g. does it really insert the records in the database if the SQL is an INSERT command?
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center