In this SQL Optimizer for SAP ASE video, we demonstrate how the Index Impact Analyzer shows the impact of adding or removing an index to a SQL statement.
Related Articles
Using CloudSQL on Google Cloud Platform with Toad Edge
Introduction Google CloudSQL is a lightweight managed service for databases with support for MySQL and PostgreSQL. CloudSQL supports most of the features supported by a local installation of MySQL and...
Spotlight on Oracle – Disks for redo devices
Disks for redo devices When a transaction is committed, the redo log entry in the redo log buffer must be written to disk. The characteristics of the redo log writes are very different from that of...
What is database schema? Objects, owners, tables and indexes
As developers of web applications for Oracle databases and for any developer who works with applications connected to a relational database, it is very important to know and understand what a database...
