SQL Optimizer 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

Webcast: Boost Database Performance with SQL Optimizer

Post author:By Quest Software

Need help with writing optimized queries for your Oracle databases? Attend this Ask Toad webcast and learn how Toad SQL Optimizer analyzes and rewrites queries.

Tags: SQL Optimizer, Toad for Oracle, webcast

SQL tools – 8 ways you can’t live (or work) without them

Post author:By Quest Software

Good SQL tools have a lot more to offer than just editing. Learn how to use them for functions all along the database development lifecycle.

Tags: SQL Optimizer, Toad for Oracle

Predict the future performance of your Oracle databases

Post author:By Jeff Surretsky

Using Spotlight® on Oracle you can predict the future performance of individual SQL statements and use the predictions to lessen future performance issues.

Tags: dba, Spotlight on Oracle, SQL, SQL Optimizer, Toad DB Admin Module, Toad for Oracle

Quest® and 23 other thought leaders predict 2020 trends

Post author:By Quest Software

Software Development Times (SD Times) gathered opinions from 24 thought leaders about where they see the software development industry heading in 2020.

Tags: Automation, Database Management Tools, Foglight for Databases, NoSQL, Sensitive Data Protection, SQL Optimizer, Toad Data Point, Toad DevOps Toolkit

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.