Select Fast! 1.0 Download

Select Fast! 1.0 Description

"a tool to automate the repetitive tasks associated with the SQL tuning process"

EditByBSEditor: It's 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 Oracle's 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.

Select Fast! 1.0 Keywords

Select Fast! 1.0 Related Software

• Fast Mail Server
  It is a super SMTP/POP3 mail server.
• Fast Video to GIF SWF Converter
  It is a conversion tool to convert any video file to animated GIF and SWFformat.
• Fast DVD Converter
  Powerful tool that lets you convert DVD to VCD, SVCD, AVI, DivX, XviD formats.
• Fast Image Resizer
  Resize images to any size in high quality quickly.
• Select-a-Net
  A Windows utility for managing multiple network and web browser configurations.
• Select Fast!
  a tool to automate the repetitive tasks associated with the SQL tuning process
• Query Plan
  It is a graphical interface to browse the shared SQL area in the SGA