What functionality is used to get the execution plans for each SQL statement in a sql script?
Launch Quest SQL Optimizer for Oracle either as standalone, or via Toad for Oracle or SQL Navigator.
1. Select 'Scan SQL' tab
2. Create a group by clicking on the list of values button [...] and entering required connection information | OK
3. Click 'Add Scan SQL Jobs' button
4. Select 'Source Code' | select the file type | click the '+' button to add files | Finish |
5. Select required jobs and click 'Scan Selected'
6. Once the scan has completed click the 'Report' button to print a report which includes execution plans for each statement.
© ALL RIGHTS RESERVED. Feedback 이용 약관 개인정보 보호정책 Cookie Preference Center