SQL Optimizer for SAP ASE Videos - Toad for SAP Solutions - Toad World

Optimize Using the Abstract Plan

26 Mar 2013 at 5:38pm
In this Quest® SQL Optimizer for Sybase ASE video we demonstrate how to tune the code even when the source code may not be available.
887 0 /

Object Extractor

26 Mar 2013 at 5:38pm
In this video we demonstrate how to use SQL Optimizer for Sybase to retrieve DDL used to recreate a database object.
813 0 /

SQL Worksheet

26 Mar 2013 at 5:37pm
In this video we demonstrate how to use SQL Optimizer for Sybase's SQL Worksheet to enter and execute multiple SQL statements and T-SQL scripts.
960 0 /

SQL Formatter

26 Mar 2013 at 5:36pm
In this SQL Optimizer for Sybase video, we demonstrate how to use the SQL formatter to transform SQL code into a more readable format.
949 0 /

Code Finder

26 Mar 2013 at 5:35pm
In this SQL Optimizer for Sybase video, we demonstrate how to use the Code Finder to search database objects and files for a specific string.
894 0 /

Performance Monitor

26 Mar 2013 at 5:34pm
In this SQL Optimizer for Sybase video, we demonstrate how to monitor the performance of your Sybase ASE server.
1102 0 /

Migration Analyzer

26 Mar 2013 at 5:33pm
In this SQL Optimizer for Sybase video, we demonstrate the Migration Analyzer evaluates the effect migrating from one database to another will have.
703 0 /

Configuration Analyzer

26 Mar 2013 at 5:33pm
In this SQL Optimizer for Sybase video, we demonstrate how the Configuration Analyzer evaluates the effect of configuration changes on SQL performance before those changes are actually committed.
733 0 /

Index Usage Analyzer

26 Mar 2013 at 5:32pm
In this SQL Optimizer for Sybase video, we demonstrate how to use the Index Usage Analyzer to determine which indexes are not being used.
856 0 /

SQL Repository

26 Mar 2013 at 5:31pm
This SQL Optimizer for Sybase video discusses the SQL repository which stores the SQL that you've identified as critical to the performance of your database.
835 0 /

Index Impact Analyzer

26 Mar 2013 at 5:30pm
In this SQL Optimizer for Sybase video, we demonstrate how the Index Impact Analyzer shows the impact of adding or removing an index to a SQL statement.
788 0 /

Index Advisor

26 Mar 2013 at 5:29pm
In this SQL Optimizer for Sybase video, we demonstrate how the Index Advisor determines whether performance can be further improved by adding an index.
1022 0 /

Batch Run

26 Mar 2013 at 5:28pm
This SQL Optimizer for Sybase video shows how to set up a batch run to compare the various SQL alternatives that have been identified.
786 0 /

Batch Run Criteria

26 Mar 2013 at 5:28pm
This SQL Optimizer for Sybase video shows how to set up a batch run criteria to compare the various SQL alternatives that have been identified.
747 0 /

SQL Comparer

26 Mar 2013 at 5:26pm
This SQL Optimizer for Sybase video demonstrates how to improve your SQL coding by viewing the SQL alternatives generated.
770 0 /