Caché Monitor features PDF Print E-mail

sql_editor_box

Caché Monitor features

  • 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 Runtime Environment 6 (Linux, Windows,...)

 


  • Caché Monitor helps you to organize your Server; to classify Caché Servers into groups, divide groups into subgroups etc.
  • 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

{mosimage}

 

 

 

Vodafone DSL Tarife

< Prev