Caché Monitor supports multiple editors and results. The sql script is formatted and colored. Result sets can be viewed in text or table format.
More features are:
Color coding of syntax to improve the readability of complex statements.
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.
InterSystems Caché® is a high-performance database that powers transaction processing applications around the world. It is used for everything from mapping a billion stars in the Milky Way, to processing a billion equity trades in a day, to managing smart energy grids. InterSystems Caché offers three integrated data access options: a robust object database, high performance SQL, and rich multidimensional access. Caché enables rapid Web application development, extraordinary transaction processing speed, massive scalability, and real-time queries against transactional data – with minimal maintenance requirements. Caché is available for Windows, OpenVMS, Mac OS X, Linux and major UNIX platforms and it is deployed on systems ranging from two to over 50,000 simultaneous users.