In this video we demonstrate how to use SQL Optimizer for SAP ASE’s SQL Worksheet to enter and execute multiple SQL statements and T-SQL scripts.
Related Articles
Spotlight on Oracle – Log File Wait Events
Log file wait events Just as Oracle sessions must wait for database file I/O, they must also wait for log file I/O. Such waits occur whenever a COMMIT statement causes a write to the redo log. The ...
Top 10 Recursive Views to Look at for Database Performance Troubleshooting
Hi, Recursive views present various data dictionary information in a readable form. In Oracle, real-time information can generally be monitored using the V$ dictionary views. Oracle tracks literally...
SQL Rewrite to Twist Cost Estimation
There are mainly three problems that database SQL optimizer cannot find the best way to process your SQL statements. Cost estimation error The cost estimation error is not only caused outdated stat...
