Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   Introduction > Features From Dynamic Server, Version 9.3 >

Query Performance Enhancements

Version 9.3 included several features that help you to monitor and improve the performance of individual queries.

New Features Reference
Display memory used by SQL statements: onstat -g stm option Virtual Portion

Session Memory

onstat -g stm session-id

onstat -g mem and onstat -g stm

Display Query Plan without executing the query Query Plan Report

EXPLAIN Directives

Displaying the Query Plan

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]