SpeedQuel

SpeedQuel is a tool used for Oracle database "flavours" - the Development Release and the DBA Release (based on the license you have). SpeedQuel specialises in providing an easy-to-use yet powerful interface to querying and developing in Oracle databases, with special features designed to aid with sql performance tuning (hence the name SpeedQuel... get it?).

Downloads

Download SpeedQuel Evaluation - v2.03 Installer (7 MB)
You may evaluate SpeedQuel for a period before purchasing any licenses. If the license expires, download it again!

Download SpeedQuel Evaluation - v2.03 standalone EXE (3 MB)
You may evaluate SpeedQuel for a period before purchasing any licenses. If the license expires, download it again!

Features Comparison

Key Features	Eval	Dev	DBA
Write and execute SQL queries and unnamed PL/SQL blocks with syntax highlighting, auto indenting etc
Write and compile named PL/SQL programs with a GUI to display and highlight errors
Quickly find schema object details using the schema browser to display object status, data, source code etc
Simple to use data grid for quick and efficient display of results with many features including sorting and scaling
Session Bar interface makes changing sessions quick and easy, including indicators to show busy and uncommited sessions
Connect to multiple sessions simultaneously - run many queries across many sessions in the fully multithreaded interface
Real-time display of fetched results
Make use of the multiple output types - data grid, execution plans, tuning information summary, DBMS_OUTPUT, history log, all accessible from a single location
Dual outputs for side-by-side comparison of data from different queries/sessions, execution plans etc
Provides a visual display of the Oracle optimizer's execution plans with collapsible tree controls and automatic highlighting of operations requiring investigation
Tuning Info - Analyses a given SQL query and gathers information required to tune it - such as indexes, statistics, and segment information for all referenced tables and indexes
Provides easy access to DBMS_OUTPUT package functionality
Supports most SQL*Plus commands such as DESC, EXEC, SPOOL, SHOW, DEFINE
Provides additional scripting commands (e.g. ignore specific errors, define script variables etc)
Supports executing SQL with bind variables (essential for good performance tuning!)
Can export results as CSV or TXT files (including automatic spooling using the SPOOL scripting command)
Detect Transparent Application Failover (a feature of RAC) and re-run any session specific settings such as default date formats
Highly optimised for prompt user response and minimal system resource usage
Frequent application updates and new features
License never expires and no nagging registration messages
More than 2 simultaneously connected sessions (Developer Release limited to 5)
More than 5 simultaneously number of connected sessions (DBA Release is unlimited)
Display currently connected-to instance of a RAC cluster
Connect to a specific RAC instance
Additional configurable security features to prevent database administration accidents
Choose which release you wish to purchase

Change History

Check out the full list of changes for all previous versions here.

SpeedQuel v2.03 (08/01/2010)

• Complete custom rewrite of query editor:
  • HUGE performance improvements across the board, especially with larger files
  • Reduced memory usage
  • Undo/Redo finally works!
  • Improved SQL and unnamed PL/SQL block parsing
  • Improved syntax colour highlighting
  • Bracket scope highlighting
  • Current query under cursor highlighting
• Format Query improvements (now handles all other statements, eg update, insert, delete, with)
• Started some memory usage tracking (via Help > About)
• Fixed Save As CSV/Text bug with LOB columns
• Fixed problem with cancel query sometimes ignoring the request
• Fixed several miscellaneous and hard to reproduce crashes and memory leaks

SpeedQuel v2.02 (27/06/2009)

• Various version number formatting changes to match new style
• Query Tab line numbers now look different for unnamed PL/SQL blocks
• Fixed some issues with parsing unnamed PL/SQL blocks within Query Tabs
• Fixed various issues with DEFINEd variables
• Fixed population of recent sessions/scripts/workspaces and keyboard shortcuts for new installations
• Spooling to CSV files now appends each new statement instead of overriding any existing file
• Added Format Query (Ctrl+M) context menu to provide simple SQL formatting
• Creates ERRORLOG.TXT if it crashes, please send this to us
• Can now disable DEFINEd variables via SET DEFINE OFF
• Change to focus handling where a script full of fast queries would keep stealing focus away from other tabs

SpeedQuel v2.01 (31/05/2009)

This is a complete rewrite of SpeedQuel with a new user interface and new and improved features! The full list of changes is enormous, so a brief summary of enhancements is:

• Completely new redesigned GUI
  • Modern look and feel
  • Dockable/customisable toolbars
  • Dockable session bar - any edge or floating
  • More flexible output windows - up to 5 at once!
  • Choose from several colour themes
• Master Tabs provide tab grouping capabilites to help fit large workspaces on screen.
• A huge number of performance and resource consumption improvements, despite the GUI enhancements SpeedQuel v2 is even leaner and faster than v1 was!
• Additional Oracle data type formats supported (vastly improved support for LOB and LONG datatypes!)
• Now works with multiple Oracle homes and the Oracle Instant Client.
• RAC aware - supports automatic failover (TAF), connect to specific instances (even without a dedicated service defined), displays currently connected instance, and more.
• Improved performance tuning feature set (better query parsing capabilities for gathering tuning info, better support for partitioned objects, parallel query execution, and more).
• Completely redesigned Browser Tab for better multi-threading and useability.
• New simplified licensing model.