What queries does Change Auditor runs against the database?
1. Stored procedures
2. Parameterized query
3. Dynamic query
4. Joined queries
5. Any other…
CA uses stored procedures a lot, most of them have at least one section that uses table joins of all types. There's left and right joins and inner joins as well.
During upgrades, CA uses Dynamic queries, to query the CA database for structure, then procedurally generate the upgrade scripts that get execute against the database to complete the upgrade.
The only query type that we don't use is the parameterized one, and primarily that is because we handle that ourselves inside the client instead of handling that at the SQL level.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. 使用条款 隐私 Cookie Preference Center