SQL Editor for InterSystems Cache and IRIS

The SQL Editor (Query Analyzer)

Caché Monitor supports multiple editors and results. The sql script is formatted and colored. Result sets can be viewed in text or table format.

query_editor_folding

More features are:

  • Color coding of syntax to improve the readability of complex statements.
  • Code folding
  • The text entered in the code editor is colored by category. The colors help you quickly find text in your code.
  • Presentation of query results in either a grid or text window.
  • A feature-rich text editing environment supporting find and replace, bulk commenting, line numbering and auto-complete.
  • The graphical SQL execution plan uses icons to represent the execution of statements and sql queries in InterSystens Cachè. This graphical approach is very useful for understanding the performance characteristics of a sql query. Index and selectivity information for used indexes are also available in the query plan.

Caché Monitor database management GUI that supports accessing InterSystems database Caché and IRIS in many versions. In addition to regular query and data browsing functionality, it includes several additional tools useful for database administrators and developers – which aims to help the DBA or developer of database application.

Meta