SQL Profiling

Graphical visualization of wait-time analysis to easily pinpoint the SQL causing poor database performance
Continuous profiling monitors an entire datasource within a configurable span of time
Explain plans for a better understanding of how SQL will be executed and the performance costs
All data and metadata pertaining to a profile session can be saved as a single entity into an archive file so profiles can be shared.
Stream profiling data into central repository
Reporting to allow sharing of information captured during the profiling process.

SQL Tuning

Batch tuning of DML statements, stored routines, and entire SQL files
Case Generation is used to generate all possible cases and find the best alternative to a given SQL statement including SQL rewrites and hint injection
The Visual SQL Tuning (VST) diagram displays indexes and constraints on tables and views with table statistics, as well as the joins used in a SQL statement such as Cartesian joins, implied Cartesian joins and many-to-many relationships.
The color-coded Index Analysis feature shows indexes that are used (green), not used (blue), or missing (orange) and offers indexing recommendations for optimum performance.

Profile chart shows the CPU, I/O, and other wait activity over the course of the profile session
Execution statistics provide detailed information about the profiled SQL and wait categories
Explain plans for each SQL statement can be computed on demand in the Execution Statistics table
Stored procedure insights