SQL Optimizer for Oracle Archives

SQL query optimization: Level up your SQL performance tuning

Post author:By Dan Hotka

Can’t find time for SQL performance tuning? Reliant on overstretched DBAs? Learn how to optimize SQL query — in minutes. Video and blog.

Tags: sql optimization, SQL Optimizer, SQL Optimizer for Oracle, sql performance tuning, Toad for Oracle

Index/SQL tuning on relational databases, why is it so darn hard?

Post author:By Quest Software

Read the blog and watch the webcast to get insights to help you appreciate why query and index performance tuning is so difficult on relational databases.

Tags: index tuning, SQL Optimizer, SQL Optimizer for DB2, SQL Optimizer for Oracle, SQL Optimizer for SQL Server, sql performance tuning, sql tuning

The performance teeter-totter part 3: Toad® Turnpike [Finding indexes]

Post author:By Gary Jerep

Optimizing SQL? Index tuning is hard. Really, really hard. Part three in a blog series about SQL optimization, index tuning and yes … even quiz answers.

Tags: Optimize, SQL Optimizer for Oracle, SQL Optimizer for SQL Server, Toad for Oracle

What is automated SQL tuning? Time saving DBA tips.

Post author:By Tim Fritz

SQL tuning alternative statements generated in hours not days. Alternative rewrites, compared with the original, easily executed side-by-side to prove which is fastest.

Tags: SQL Optimizer, SQL Optimizer for DB2, SQL Optimizer for Oracle, SQL Optimizer for SAP ASE, SQL Optimizer for SQL Server

Coffee with Toad [Toad World Annual recap, 96 blogs]

Post author:By Quest Software

In 2019 Toad World published nearly 100 blogs. You’ll find blogs on our products, thought leadership, cutting edge technology and even a few on Oracle.

Tags: ApexSQL, Benchmark Factory, Database Management Tools, Oracle, Sensitive Data Protection, SQL Optimizer, SQL Optimizer for Oracle, Toad Data Modeler, Toad Data Point, Toad Data Point Workbook, Toad DevOps Toolkit, Toad Edge, Toad for SAP Solutions, Toad for SQL Server, Toad Intelligence Central

SQL in COBOL? Find and tune your SQL wherever it is.

Post author:By Jeff Surretsky

Do you embed your SQL in COBOL? Even if you don't, toad can proactively fin and tune your SQL wherever it is.

Tags: Optimize, scan, SQL Optimizer, SQL Optimizer for Oracle, SQL Optimizer for SQL Server, toad, Toad for Oracle, Toad for SQL Server, tune

SQL Optimizer for Oracle – Un caso real de optimización de una consulta SQL

Post author:By Clarisa Maman Orfali

Conozca cómo un DBA utilizó SQL Optimizer for Oracle para reducir un proceso que tomó más de seis horas originalmente a solo 23 minutos después de la optimización.

Tags: SQL Optimizer for Oracle