|
|
Please check back to this page as upgrades or patches are released for details.
For information on high-level features introduced in version 3, please visit our What's New information page.
Current Version: 3.1.4.2
Enhancements / Corrected Defects
| General | Updated the base display to utilize the Windows XP Look and Feel when using the Windows XP Operating System. |
| Oracle Documentation Integration | Updated logic for parsing and integrating with the latest release of Oracle's 10gR2 documents. |
| PL/SQL Debugger | Updated starting position on the Call Stack interface to ensure that the proper line would be selected when viewing the source. |
| PL/SQL Debugger | Updated the Call Stack's logic to ensure that the SQL Editor would recieve focus when the option to view source is used. |
| PL/SQL Debugger | Updated the Breakpoint List's logic to ensure that the SQL Editor would recieve focus when the option to view source is used. |
| Export Data | Introduced a completely new Data Export interface allowing for several more options. |
| Telnet Client | Added a Telnet Client Interface, now available from the View Menu under Network Utilities. |
| Remote Execution (RExec) | Added a Remote Execution (RExec) Interface, now available from the View Menu under Network Utilities. |
| Remote Shell (RSH) | Added a Remote Shell (RSH), now available from the View Menu under Network Utilities. |
| Ping | Added a Ping Interface, now available from the View Menu under Network Utilities. |
| TNSPing | Added a TNSPing Interface, now available from the View Menu under Network Utilities. |
| SQL Trace | Added additional logic to turning on SQL Trace, in which you may now set the desired level. |
| SQL Trace | Added an informational display of some base server settings concerning the SQL Trace and trace files. |
| TKProf Utility | Added a TKProf Utility to provide an interface to TKProf in the Database menu, allowing for several files to be processed at once with all possible TKProf options. |
Enhancements / Corrected Defects [3.1.3.9]
| Oracle Documentation Integration | Added functionality for integration to the Oracle Database Documentation Library. |
| Oracle Documentation Integration | Added ability to view and search Oracle books and topics. |
| Oracle Documentation Integration | Added ability to view and search Oracle error messages, causes, and actions. |
| Oracle Documentation Integration | Integrated error descriptions found within Oracle Documentation to error windows displayed within the application. |
| Oracle Documentation Integration | Integrated the SQL Editor with the Oracle Documentation searching to provide single-click definition lookups. |
| SQL Editor | Created display properties to underline the word under the mouse cursor while the Control key is held down (displayed post-Integration). |
| SQL Editor | Added "Find Definition" to the popup menu when opened atop a word within the SQL Editor. |
| General | Optimized use of the internal image mapper, thus providing a system-wide performance increase. |
| About | Updated the About window to provide the full version number (X.X.X.X) instead of only displaying the major and minor numbers. |
Enhancements / Corrected Defects [3.1.2.16]
| Describe | Corrected defect in which an error could be encountered when using the drop-down tab selection. |
Enhancements / Corrected Defects [3.1.2.14]
| PL/SQL Debugger | Defect correction for "Step Out" method call to return execution to expected location. |
| PL/SQL Debugger | Added additional methodology to detect method termination. |
| PL/SQL Debugger | Added additional measures to prevent attempted debugging of unavailable objects. |
Enhancements / Corrected Defects [3.1.2.5]
| Check Query Joins | Increased accuracy of column names returned when locating possible joins. |
| Auto-Tune | Auto-Tune will now continue processing if no joins where selected from the initial Check Query Joins. |
| Auto-Tune | Increased accuracy of the unnecessary table removal process. |
| Auto-Tune | Corrected defect that caused no variations to be displayed when truncated date parameters where being used in the original statement. |
| Auto-Tune | Added new option to create the suggested index for a listed variation. |
| Auto-Tune | Added new option to start a new Auto-Tuning process based upon the selected variation. |
| Auto-Tune | Added the Send To functionality present elsewhere in the system to the listing of variations. |
| Database Browser | Reinstated the Classic Database Browser, which contains the database tree and a static describe window, eliminating the necessity to double-click. |
| Miscellaneous | Added the Classic Database Browser and Auto-Tune buttons to the default selection for the tool bars. |
| Miscellaneous | On the Professional Edition, removed the Call Stack and Variable List buttons from the default selection for the tool bars (they are still available from the View->Debug Windows menu). |
| Miscellaneous | Corrected defect which possibly displayed SQL Insight's About Box when trying to open a new file. |
Enhancements / Corrected Defects [3.1.1.8]
| Oracle 8i | Corrected defect inhibiting the database browser, describe windows, and some DDL generators from functioning within an Oracle 8i database. |
| Auto-Tune | Improved response when cancelling the statement generation process. |
| Auto-Tune | Overall optimization to improve the statement generation process. |
Enhancements / Corrected Defects [3.1.0.29]
| Add Referential Integrity | Added the option to create a foreign key constraint on a selected table from the Database Browser via the right-click menu. |
| Add Index | Added the option to create an index on a selected table from the Database Browser via the right-click menu. |
| Database Browser | Modified drag-and-drop procedure to generate a comma-seperated list when dragging objects from the browser into an SQL Editor. |
| SQL Editor | Added "Set Bookmark" and "Goto Bookmark" menu options, available in the right-click menu and from the 'Edit' main menu. |
| Miscellaneous | Corrected defect in which all toolbar buttons become enabled when focusing an MDI window other than a Session Window. |
| Auto-Tune | We now perform a check for a trailing semi-colon before attempting the Auto-Tune process. |
| Auto-Tune | Added Menu item image for the Auto-Tuner and associated accordingly with the Project Manager. |
| Check Query Joins | We now perform a check for a trailing semi-colon before attempting the Check Query Joins process. |
| Describe | Corrected defect in which an error could be encountered when using the drop-down tab selection. |
| Image Library | Corrected defect which removed image transparency on tool bar items. |
Enhancements / Corrected Defects [3.1.0.26]
| Auto-Tune | Added the Auto-Tune feature in the Run menu which will automatically parse and reconstruct poor-performing SQL statements to produce faster, more reliable variations.
 View Image |
| Navigator | Added a Navigator tab to My Insight which provides file compilation and simplified navigation while working with code. |
| New Database Objects | Within the database browser, describe, schema comparisons, and other areas of SQL Insight, the following object types have been added for use: Database Links, Dimensions, Materialized Views, Materialized View Logs, and Stored Outlines. |
| Auto-Completion | Made the possible Auto-Completion hints "scrollable" using the scroll keyboard shortcuts "Ctrl+Up" and "Ctrl+Down". |
| Auto-Completion | Introduced Auto-Completion Statistics gathering, which tracks those completions used more prevelently to help decide how the Auto-Completion may work best for you. |
| Auto-Completion | Within the options, allowed for the specification of an input file allowing the same configuration file to be shared by networked computers. |
| New Wizard | For the Database Links, we have added a "New Database Link" wizard available from the Database menu and the database browser. |
| DBMS Output | Introduced the ability to view the output of the HTP or HTF packages through DBMS Output or an external browser. |
| SQL Editor | Made file "tabs" non-focusable, which means that they will not capture the keyboard input when switching between files. |
| SQL Editor | Corrected defect which would default the editor to the wrong highlighter when a file is opened. |
| SQL Editor | Corrected defect in which a user could receive errors when closing a SQL Builder window. |
| Drop Object | Corrected defect which would not allow a java source object to be dropped. |
Enhancements / Corrected Defects [3.0.11.18]
| Grid / Query Results | Corrected critical defect which halted the ability to filter grid columns. |
| FTP Client | Corrected all known issues with FTP Connection stability and reenabled status displays. |
| Custom Highlighters | Corrected all known issues with custom highlighters. |
| Custom Highlighters | Added option for case sensitivity when designating reserved words. |
| Custom Highlighters | Added string delimter of "Either" to allow both single quoted and double quoted strings. |
| Custom Highlighters | Added option to utilize the preprocessor element or ignore it. |
| Highlighter Configuration | Redesigned layout for ease of use. |
| Highlighter Configuration | Added ability to load a custom highlighter from a configuration file.
Click here to download new highlighters. |
| Database Browser | Added "Recycle Bin" to the database browser (per schema), with functionality to purge and restore objects within (Oracle 10g or higher). |
| Database Browser | Added "Trash" to the database browser (per schema), allowing drag-and-drop for the quick removal of objects from a schema (Oracle 9i or previous). |
Enhancements / Corrected Defects [3.0.9.2]
| FTP Client | Corrected some known issues with FTP Connection stability. |
| Support Documentation | Updated Documentation to reflect last version's modifications and included additional topic links. |
Enhancements / Corrected Defects [3.0.8.8]
| Update Schema | Moved checking public synonyms to another step (performance increase). |
| Update Schema | Added warnings for possible alteration / compilation errors. |
| Update Schema | Implemented display containing number of modifications and warnings found during analysis. |
| DDL Generation | Increased performance on Table DDL generation, affecting Describe, Update Schema, and Schema Script generation performance. |
| General | Re-implemented the closing of session-dependant windows on a database disconnect. |
| Describe | A user / schema may now be described through the Session Editor (using "desc" command or by pressing F11), which will display a database browser filtered to the described user. |
Enhancements / Corrected Defects [3.0.8.6]
| Session Editor | Removed shortcut for closing the current page. |
| Session Editor | Corrected various points in which a semi-colon at the end of a statement caused unnecessary errors. |
| PL/SQL Debugger | Corrected defect which would freeze system on heavy calls to DBMS_Output. |
| Update Schema | Added "Update Schema From..." option to the database browser, allowing you to generate a series of DDL scripts to upgrade the selected schema from another.
View Image |
| Explain Plan | Corrected defect of "Invalid Floating Point" when extremely large executions where displayed. |
| Explain Plan | Modified the selected object's describe information to display the object name within the header. |
| Explain Plan | Added ability to drag-out the selected object's describe information into a new describe window. |
| Explain Plan | Added option within the Database Options to hide or display the information/describe details on the Explain Plan. |
| Explain Plan | Modified the default display size of the various windows to present the necessary information more clearly. |
| Export Data | The option to ReExecute Query is not checked if the number of rows returned is known (displayed on the Grid's status panel). |
| Database Connections | Corrected defect pertaining to the location/utilization of certain Oracle 10g Client information. |
| Describe | Corrected describe refresh shortcut (F5). |
| Text Comparisons | Corrected all known defects pertaining to text comparisons. |
| General | All tool windows (those with the gradient header) will display their appropriate menu, if available, when F10 is pressed. |
| General | Drastically improved system-wide performance and removed unnecessary CPU usage. |
| About | Added License Number and, if applicable, Registration Number to the About window for user reference. |
Enhancements / Corrected Defects [3.0.7.4]
| Check Query Joins | Added "Check Query Joins" item to the Run menu, which parses a query and locates/corrects any potentionally missing joins.
View Image |
| Online Updates | Added functionality to display version numbers and descriptions of a download release. |
| DDL Script Generation | Corrected defect in which a "default" within a parallel clause was being converted to a number. |
| Execute Loop | Disabled menu item when database is unavailable. |
This high-level enhancement list was generated as of version 3.0.8.6
Additional enhancements and defects corrections may be present in the current version.
For the history of previous revisions, please view SQL Insight 2 Revision History.
|