SQL Manager offers you the following features, which significantly enhance the functionality of the basic SQL Editor component:
| SQL Tuner | SQL Tuner helps database administrators and developers to build the high-performing SQL code. It provides facilities that significantly simplify a task of creating new or re-wring existing SQL queries. SQL Tuner automatically checks SQL statements for basic Informix specific SQL design "rules-of-thumb" violations defined by Informix experts and generates alternative SQL that corrects them. It can execute multiple versions of SQL statement and presents graphical explain plans and execution statistics for easy comparison. Integrated Index Adviser performs a thorough examination of specified SQL statements and presents index recommendations based on tables which are used by these statements. |
| Query Designer | The Query Designer provides an interactive modeling environment that helps developers meet the challenges of creating database queries without the need of dealing with the intricacies of the SQL query language, remembering the table and column names, data types, and special operators for filtering and sorting the results. |
| LOAD and UNLOAD statements support | LOAD and UNLOAD statements provide data import and data export functionality from SQL scripts. Server Studio implementation of these statements allows extended syntax in comparsion to dbaccess implementation, which incudes ability to log errors to a text file, export data with a headers, import and export range of rows from a file and other options. |
| Query Execution Plan Analyzer | Integrated graphical Query Execution Plan Analyzer allows you to get output of EXPLAIN PLAN for all statements in the SQL script or just a selected portion of it. It helps you to tune performance of your SQL queries by analyzing, which indexes are used by Informix query optimizer. Execution Plan is presented in a form of a diagram as well as a tree. |
| Code Completion | Code completion feature helps to look up and finalize table, views and column names during code development by popping up the available database objects, their attributes and context-dependent SQL keywords lists in any SQL Editor component . |
| Related Data Links in query result sets | When this feature is activated, the editor performs analysis for retrieved query data sets based on identifiable primary/foreign keys in SELECT column list and displays navigation links to view related data for cells that have primary/foreign keys relations. |
| SQL Formatter | SQL Formatter component formats and beautifies individual Informix SQL statements, SQL scripts and SPL stored procedures and triggers with many formatting options. |
| Charting of Query Result Sets | This function provides an ability to graph query results in SQL Editor using multiple chart types, such as pie, bar and XY charts. |
| Printing Support | The contents of any SQL Editor or any SQL syntax viewer within the Server Studio can be printed. You can also print query results produced by running SQL SELECT statement in the SQL Editor. |
| SQL Templating | You can use predefined Informix SQL and SPL syntax templates, when writing scripts in the SQL Editor. All templates can be edited and extended by the user to meet the specific organizational needs. |
| Image Viewer | The Image Viewer allows you to view graphical images stored in BLOB and BYTE table columns and also view graphical text files. |
| Command-line SQL Runner | You can execute SQL scripts by invoking Server Studio in a command line mode. This feature allows using Server Studio with an external scheduler and in automated application deployment tasks. SQL scripts can include special LOAD and UNLOAD SQL statements to import and export data files as part of script’s logic. |
| Color-Coding | All SQL Editors and SQL syntax viewers within Server Studio are color-coded for Informix specific SQL and SPL languages. |