Caché Monitor features

* Advanced SQL Query Editor
o Caché-SQL Syntax highlighting
o SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
o SQL History buffer for executed SQL commands
o SQL Code formatting
o Parallel (multi-threaded) queries
o The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
o SQL abbreviations, Type: se to complete to "SELECT * FROM "
o TuneTable for selected Tables or whole Namespaces
o Select2Table Function

* DDL Code generation (CREATE TABLE)
* MetaData-Browser for
o Namespaces
o Tables
o Views
o Routines
o Classes
o CachedQueries
o Stored Procedures
o Indexes
* It can be used from any platform with an JAVA-JRE 5.0 (Linux, Windows,...)


* You can structure your CacheServer in arbitrary groups
* You can see Cache Version infos from connected Server
* Shows Executionplan from an SQL Statement.
You can view the selectivity from the used columns in the execution plan
* Shows CachedQueries with their costs and the underlying SQL
(AddHoc from Intersystems needed!)
* Select2Table Function
* Fast open Query Analyzer with CTRL+Q on selected Server
* Fast open Query Analyzer with CTRL+O
* CopyTable Function
* Execute TuneTable for selected Tables or the whole Namespace
* Shows PID (ProcessID) from each Query Analyzer connection
* Shows Processlist
* Shows SELECT-Statements from SQL Views
* Show Routines