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

Product Training

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.
943 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.
869 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.
1005 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.
1011 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.
949 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.
1170 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.
762 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.
785 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.
900 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.
939 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.
839 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.
1092 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.
832 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.
785 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.
808 0 /