SAP Sybase IQ
16.0 SP2 introduces new query plan
nodes.
New Query Plan Nodes
Node Change
Description
Projection Cache Dbspace Stats
New node indicating:
HitRate – Percentage of hit count in the total cache dbspace
read count.
Finds – Total cache dbspace read count.
Hits – Hit count.
Pageouts – Count of pages written to the cache dbspace by the
buffer manager.
IOms – Time, in milliseconds, the buffer
manager took to read to and write from the cache
dbspace.
Condition <n> Cache Dbspace
Stats
New node indicating:
HitRate – Percentage of hit count in the total cache dbspace
read count.
Finds – Total cache dbspace read count.
Hits – Hit count.
Pageouts – Count of pages written to the cache dbspace by the
buffer manager.
IOms – Time, in milliseconds, the buffer
manager took to read to and write from the cache
dbspace.
New Query Details
The Query Details area of the plan contains these changes:
Two new rows for TEXT index-based prefiltering: Adjunct
Index, Adjunct constraint. These rows existed in previous releases for WD
index-based pre-filtering only.
New row showing the number of rows remaining after pre-filtering.
New row specifying the type of subquery: Distribute Sort
Based Uncorrelated IN subquery.
CPU Utilization Bar Graph Changes
Increased resolution – A new tooltip over the user (green) / system (red) CPU
usage bar shows CPU utilization percentage.
In a multiplex, the leader node query plan shows CPU
utilization against the total number of available cores in the cluster.
Thread Utilization Bar Graph Changes
Increased resolution – If the maximum number of threads is >100, then thread utilization shows
as a percentage.
A new tooltip over the thread utilization bar shows the utilization
percentage.