Examples (Embarcadero DB Optimizer)

Examples

Oracle

SQL Tuning (optimizer errors)

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

Subpages (4): Commit Frequency (Oracle) Nested Loops (Oracle) Tunable Queries Tuning - select with outlier (oracle)