Cach? Monitor 0.29 review

License: Freeware File size: 0K Developer: Andreas Schneider

0

Cache Monitor project is an SQL development tool for InterSystems database Cache.

Here are some key features of "Cach? Monitor":
Advanced SQL Query Editor
Cach?-SQL Syntax highlighting
SQL Code completion for Tables,Views,Columns and Indexes (also known as Intellisense)
SQL History buffer for executed SQL commands
SQL Code formatting
Parallel (multi-threaded) queries
The Graphical SQL execution plan supplies index and selectivity information from every used index in the plan
SQL abbreviations, Type: se to complete to "SELECT * FROM "
TuneTable for selected Tables or whole Namespaces
Select2Table Function
DDL Code generation (CREATE TABLE)
MetaData-Browser for
Namespaces
Tables
Views
Routines
Classes
CachedQueries
Stored Procedures
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 Analyser with CTRL+Q on selected Server
Fast open Query Analyser with CTRL+O
CopyTable Function
Execute TuneTable for selected Tables or the whole Namespace
Shows PID (ProcessID) from each Query Analyser connection
Shows Processlist
Shows SELECT-Statements from SQL Views
Show Routines

Requirements:
Java 1.4.2 or later
JDK 1.5

What's New in This Release:
A first version of the "CREATE TRIGGER" function was added.
CachedQuery Details are now scrollable.
A "Tip of the Day" dialog was added.
Copying server no longer copies the cached namespaces.
The "next" SQL can be executed by pressing F7.
More datatypes are colored.
The "change" dialog now really saves the file if user selects "SAVE".
A parsed query no longer formatted as uppercase.
If a result is text, the message tabs are no longer selected if an error occurs.
The context menu also works on the first data row in the "Table details" tab.