Examples

From DB Optimizer
Jump to: navigation, search

Examples

Oracle

SQL Tuning (optimizer errors)
* select with outliers
* People Soft query
* People Soft query simplified
DBMS Platform Create Schema SQL Load Files SQL Profile Session Files SQL Tuning Job Files
Oracle PeopleSoftData.zip PeopleSoftDemo.osl PeopleSoftDemo.oar PeopleSoftDemo.tun
PeopleSoftDemohints.osl

Load Editor & Profiler

* Parsing : Library Cache Latch
* Nest Loops : cache buffers chains latch
* Commits : log file sync


Cross Platform

DBMS Platform Create Schema SQL Load Files SQL Profile Session Files SQL Tuning Job Files
Oracle gimdata_oracle.zip Oracle Demo.osl Oracle Demo.oar Oracle Demo.tun
Oracle Demo hints.osl
SQL Server gimdata_mssql.zip Sql Server Demo.osl Sql Server Demo.oar Sql Server Demo.tun
Sql Server Demo hints.osl
Sybase gimdata_sybase.zip Sybase Demo.osl Sybase Demo.oar Sybase Demo.tun
Sybase Demo hints.osl
DB2 gimdata_db2.zip DB2 Demo.osl DB2 Demo.oar DB2 Demo.tun
DB2 Demo hints.osl
Personal tools