a tool to automate the repetitive tasks associated with the SQL tuning process
Edit By BS Editor: Its a tool to automate the repetitive tasks associated with the SQL tuning process on the Oracle Database. With Select Fast!, you can easily write and keep track of all alternative query versions you Create during the tuning process, run them at once to collect statistics, run EXPLAIN PLAN, Capture plan from V$SQL_PLAN, set bind variables and session level initialization parameters, etc. Its multi-threaded UI lets you run queries on several databases at the same time, and continue working on new ideas.
Features
Multi-connection support: you can use one account to run your statements and other one to query V$ views, so no need to give extra privileges for tuning (this allows finer security control). Select Fast! detects existing privileges automatically and use them.
Generate Execution plans with the EXPLAIN PLAN command.
Capture execution plans from V$SQL_PLAN, with statistics from V$SQL_PLAN_STATISTICS_ALL.
Perform test runs for queries to get execution statistics, with multi-threaded support to do it in background, while using other features.
Share your thoughts! Ability to save entire analysis as a file allows teamwork in the tuning process to achieve better results.
Define bind variable values and session-level initialization parameter to analyze its effects on query execution and query plans.
Control over timeout and record count limits for executions.
Interface to Oracles Tuning Advisor.
Practical User Manual.
Automatic conversion of time units for elapsed time and CPU time for Readability.
Also featured for Java, supporting JDBC bind variable syntax (with ?).
Oracle connection through .NET Data Provider (no need to install any lib, only the Oracle Client).
Small footprint: a single .NET executable file with Little more than 500k. you can free download Select Fast! 1.0 now.