This video shows how to identify SQL statements in need of tuning with Spotlight on Oracle.
Related Articles
Criteria for Selecting Best SQL
This tip covers how to consider the disk I/O when selecting the best SQL alternative. When selecting the best performing SQL statement for your application, how should disk I/O be weighed in compariso...
Configuring an Oracle Database to have a ‘self-cleaning’ PLAN_TABLE
On the database server, go to $ORACLE_HOME/rdbms/admin copy utlxplan.sql to utlxplan.sql.original – you don’t want to lose the original Oracle script. Edit utlxplan.sql and change it to the following...
Using SQL Server Data Encryption in Toad for SQL Server
SQL Server supports data encryption to encrypt, or obfuscate, data so that confidential data may be protected. Data encryption is provided using Transact-SQL functions, passwords, cryptographic keys, ...
