SpeedQuel The tool for Oracle database development and administration
Download

SpeedQuel Ranking & Summary

SpeedQuel Tags

query database management Administration Oracle database Oracle administration database development tool Oracle Development Tool

SpeedQuel Description

SpeedQuel specialises in providing an easy-to-use yet powerful interface to querying and developing in Oracle databases. It has many special features designed to aid with SQL performance tuning. It is extremely light-weight and uses the native Oracle OCI API to provide the fastest and most efficient communications with the database. Take SpeedQuel for a test drive to fully assess its capabilities! Main features: Connectivity: Session Bar interface makes changing sessions quick and easy, including indicators to show busy and uncommited sessions 5 simultaneously connected sessions Connect to multiple sessions simultaneously - run many queries across many sessions in the fully multithreaded interface Query Editor: 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 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!) Results Display: 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 Can export results as CSV or TXT files (including automatic spooling using the SPOOL scripting command) Highly optimised for prompt user response and minimal system resource usage

SpeedQuel Related Software