Performance Problems after transporting database to a new server

[Former Member]

Hi,

I transported the data from my old MaxDB server (Kernel 7.6.00 build 037-121-149-748) to a new server (Kernel 7.6.06 build 003-123-202-135) using the current version of Database Studio. Now I am having massive performance problems. For instance, a query that used to run in 40ms on the old and slow server now takes 15000ms. The query and the table structure are included at the end of this post. Both servers are running WindowsXP SP2 32bit with 2GB RAM. The new server is dual core.

As a test, I disabled the index on the new server, and the query still ran in 15000ms. Even though EXPLAIN says the index is being used, I suspect the query is not using the index. I also used the database analyzer to search for a problem, but I cannot find anything suspicios. Could it be the sample size or other parameters are different in both databases and thus the optimizer chooses different query execution plans?

Can anyone help me with my problem?

Thank you and kind regards,

Leonardo

// This table has 1.000.000 rows

CREATE TABLE "FIELDTEST-100-1k"

("HEX" Varchar (100) ASCII,

"READER" Varchar (10) ASCII)

CREATE INDEX "FIELDTEST-100-1k-HEX,READER"

ON "FIELDTEST-100-1k" ("HEX" ASC,"READER" ASC )

ALTER INDEX "FIELDTEST-100-1k-HEX,READER"

ON "FIELDTEST-100-1k" ENABLE

SELECT HEX,

SUM(CASE WHEN F."READER" = 'RACK1' THEN Event ELSE 0 END) AS EventOK,

SUM(CASE WHEN F."READER" != 'RACK1' THEN Event ELSE 0 END) AS EventWrong

FROM

(SELECT HEX, READER, COUNT(*) AS Event

FROM "FIELDTEST-100-1k"

WHERE SUBSTR(HEX,4,11) = '10442001784'

AND "READER" != 'POS'

AND "READER" != 'Lager'

GROUP BY HEX, READER) AS F

GROUP By HEX

[lbreddemann]

Hi Leonardo,

is it correct that your table has no defined primary key?

This alone will likely make the use of the Index likely.

Based on the (partial) query

SELECT HEX, READER, COUNT(*) AS Event 
FROM "FIELDTEST-100-1k" 
WHERE SUBSTR(HEX,4,11) = '10442001784' 
AND "READER" != 'POS' 
AND "READER" != 'Lager' 
GROUP BY HEX, READER

I can tell you, that this query won't ever use the index "FIELDTEST-100-1k-HEX,READER" for filtering the data.

That's because:

1. MaxDB cannot apply the SUBSTR to the field value and still make use of the index.

and

2. MaxDB cannot do a skip scan - so not even a range scan excluding READER = POS and READER=Lager can be done via the index.

Therefore, MaxDB will read the whole index here but don't get any benefit from it performance wise except for the grouping (since the order of the data is used for that).

So the question here is rather: why is the query so quick on the original database?

What about Cachesize?

What about the OPTIMIZE_INDEX_ONLY parameter?

Please post the execution plans for both instances.

regards,

Lars

[Former Member]

Hi Lars,

thanks for the reply. Yes, there is no primary key. Both databases have the same (default) parameters for cache:

CATCACHE_MINSIZE 262144

DATACACHE_RGNS 8

CACHE_SIZE 300

CAT_CACHE_SUPPLY 3264

HASHED_RESULTSET_CACHESIZE 262144

OPTIM_CACHE NO

PROTECT_DATACACHE_MEMORY NO

SEQUENCE_CACHE 1

SHAREDSQL_COMMANDCACHESIZE 262144

USE_SYSTEM_PAGE_CACHE YES

XP_DATA_CACHE_RGNS 0

I could not find the parameter OPTIMIZE_INDEX_ONLY with Database Studio. Where is it?

Here is the result of EXPLAIN for the old server:

OWNER;    TABLENAME;        COLUMN_OR_INDEX;      STRATEGY;                       PAGECOUNT;
TEST;     FIELDTEST-100-1k; FIELDTEST-100-1k-...; INDEX SCAN;                     200
;         ;                 ;                     ONLY INDEX ACCESSED;
INTERNAL; TEMPORARY RESULT; ;                     TABLE SCAN;                     1
;         JDBC_CURSOR_31;   ;                     RESULT IS COPIED, COSTVALUE IS; 603

And for the new server

OWNER;    TABLENAME;        COLUMN_OR_INDEX;      STRATEGY;                       PAGECOUNT;
TEST;     FIELDTEST-100-1k; FIELDTEST-100-1k-...; INDEX SCAN;                     200
;         ;                 ;                     ONLY INDEX ACCESSED;
INTERNAL; TEMPORARY RESULT; ;                     TABLE SCAN;                     1
;         JDBC_CURSOR_16;   ;                     RESULT IS COPIED, COSTVALUE IS; 603

PS: I had a typo on the runtime in my previous post: it is 1.500ms and not 15.000ms on the new server.

PS about the index: removing the index from the table on the old database will make the query run in 2.000ms instead of 40ms, so the index seems to be making a big difference there. I tried using other things instead of the SUBSTRING, but there is no change in performance, e.g.

WHERE HEX LIKE '30410442001784%'

WHERE HEX > 304104420017840000000000 AND HEX < 304104420017849999999999

Kind regards,

Leonardo

[lbreddemann]

Hi Leonardo,

> PS about the index: removing the index from the table on the old database will make the query run in >2.000ms instead of 40ms, so the index seems to be making a big difference there.

Yes - please read carefully, what I've written before.

The index will not be used to filter the data.

Instead the index is always completely scanned and only used to have the rows in a defined order.

>I tried using other things instead of the SUBSTRING, but there is no change in performance, e.g.

> WHERE HEX LIKE '30410442001784%'

> WHERE HEX > 304104420017840000000000 AND HEX < 304104420017849999999999

Have you checked the execution plan for those changed statements?

Depending on how selective the index range will be, it might be chosen.

Anyhow - not defining a proper primary key is not only something bad in relational databases in general but comes with a performance penalty in MaxDB.

Remember MaxDB stores all data in Btrees and Btrees need a key.

If you don't supply a key, MaxDB will create one internally.

So you not only cannot access your data properly, but you've to store additional data as well.

About the parameter: ok, this was a typo. The correct parameter name is OPTIM_INV_ONLY.

Anyhow, a cache size of 300 is nearly a guarantee for disk accesses during the statement processing.

What about the performance difference, when you stop/start both databases and re-run the statements then?

Still so much difference?

regards,

Lars

[Former Member]

Hi Lars,

the parameter OPTIM_INV_ONLY is set to yes on both databases.

The cache of 300 was a typo, I meant 3.000. Sorry for that.

After putting the old database offline and then online again I get the following runtime:

Statement '...' successfully executed in 500 ms.

Statement '...' successfully executed in 31 ms.

Statement '...' successfully executed in 16 ms.

And on the new database:

Statement '...' successfully executed in 2.046 seconds.

Statement '...' successfully executed in 1.468 seconds.

Statement '...' successfully executed in 1.484 seconds.

Kind Regards,

Leonardo

[lbreddemann]

Hi Leonardo,

have you tried to run both databases on the same host?

Maybe the I/O performance is worse than it was on the original system.

Please activate the time measurement for both DBs:

x_cons <SID> enable timing

and make sure the DBAnalyzer is running.

also please post all parameters for both databases (or better: provide a download link for the files).

regards,

Lars

[holger_becker]

Hi,

to check if the execution is really the same on both server I would suggest to execute this command sequence on both server

monitor init

//

your select

//

select * from monitor

and post the result of the monitor select to this list.

Kind regards

Holger

[Former Member]

Hi Holger,

Bellow you will the find results of both monitors. The following cauth my attention on the new server, I don't know if it is relevant:

Hash join failed because of memory	0
Hash join failed because of small buffer	0

Thank you and kind regards,

Leonardo

OLD SERVER:

TYPE	DESCRIPTION	VALUE
CACHES	Data cache accesses	2279
CACHES	Data cache accesses successful	2250
CACHES	Data cache accesses unsuccessful	29
CACHES	Data cache hit rate (%)	99
CACHES	Catalog cache accesses	753
CACHES	Catalog cache accesses successful	626
CACHES	Catalog cache accesses unsuccessful	127
CACHES	Catalog cache hit rate (%)	83
CACHES	Sequence cache accesses	0
CACHES	Sequence cache accesses successful	0
CACHES	Sequence cache accesses unsuccessful	0
CACHES	Sequence cache hit rate (%)	0
CACHES	Data cache sqlpage accesses	2279
CACHES	Data cache sqlpage accesses successful	2250
CACHES	Data cache sqlpage accesses unsuccessful	29
CACHES	Data cache sqlpage hit rate(%)	99
CACHES	Data cache OMS accesses	0
CACHES	Data cache OMS accesses successful	0
CACHES	Data cache OMS accesses unsuccessful	0
CACHES	Data cache OMS hit rate (%)	0
CACHES	Data cache OMS log accesses	0
CACHES	Data cache OMS log accesses successful	0
CACHES	Data cache OMS log accesses unsuccessful	0
CACHES	Data cache OMS log hit rate (%)	0
CACHES	Data history/undo accesses	0
CACHES	Data history/undo accesses successful	0
CACHES	Data history/undo accesses unsuccessful	0
CACHES	Data history/undo hit rate (%)	0
CACHES	Data cache no of SQL data pages	105
CACHES	Data cache no of OMS data pages	0
CACHES	Data cache no of history/undo pages	0
CACHES	Data cache no of unloaded version pages	0
LOAD	SQL commands	253
LOAD	PREPAREs	37
LOAD	PREPAREs repeated	3
LOAD	EXECUTEs	57
LOAD	COMMITs	7
LOAD	ROLLBACKs	4
LOAD	LOCKs and UNLOCKs	0
LOAD	SUBTRANS BEGINs	0
LOAD	SUBTRANS ENDs	0
LOAD	SUBTRANS ROLLBACKs	0
LOAD	CREATEs	1
LOAD	ALTERs	0
LOAD	DROPs	0
LOAD	SELECTs and FETCHes	81
LOAD	SELECTs and FETCHes, rows read	542
LOAD	SELECTs and FETCHes, rows qual	120
LOAD	INSERTs	1
LOAD	INSERTs, rows inserted	0
LOAD	UPDATEs	0
LOAD	UPDATEs, rows read	0
LOAD	UPDATEs, rows updated	0
LOAD	DELETEs	0
LOAD	DELETEs, rows read	0
LOAD	DELETEs, rows deleted	0
LOAD	Internal DBPROC calls	15
LOAD	External DBPROC calls	0
LOAD	Internal trigger calls	0
LOAD	External trigger calls	0
LOAD	Primary key accesses	0
LOAD	Primary key accesses (IN strategy)	0
LOAD	Primary key accesses (SUBQ strategy)	0
LOAD	Primary key accesses, rows read	0
LOAD	Primary key accesses, rows qual	0
LOAD	Primary key range accesses	7
LOAD	Primary key range accesses, rows read	5
LOAD	Primary key range accesses, rows qual	5
LOAD	Index accesses	0
LOAD	Index accesses (IN strategy)	0
LOAD	Index accesses (SUBQ strategy)	0
LOAD	Index scan	0
LOAD	Index accesses, rows read	0
LOAD	Index accesses, rows qual	0
LOAD	Index range accesses	0
LOAD	Index range accesses, rows read	0
LOAD	Index range accesses, rows qual	0
LOAD	Isolated index accesses	0
LOAD	Isolated index accesses (IN strategy)	0
LOAD	Isolated index accesses (SUBQ strategy)	0
LOAD	Isolated index accesses, rows read	0
LOAD	Isolated index accesses, rows qual	0
LOAD	Isolated index range accesses	0
LOAD	Isolated index range accesses, rows read	0
LOAD	Isolated index range accesses, rows qual	0
LOAD	Table scans	27
LOAD	Table scans, rows read	495
LOAD	Table scans, rows qual	115
LOAD	Isolated index scans	0
LOAD	Isolated index scans, rows read	0
LOAD	Isolated index scans, rows qual	0
LOAD	Memory sorts / sort&merge	0
LOAD	Memory sorts / sort&merge, rows read	0
LOAD	Sorts by insertion	23
LOAD	Sorts by insertion, rows inserted	87
LOAD	Join via Hash	0
LOAD	Join via parallel index read	0
LOAD	Join via standard algorithm	0
LOAD	Join via operator join	0
LOAD	Join via improved operator join	6
LOCK	Lock list avg used entries	0
LOCK	Lock list max used entries	2400
LOCK	Lock list collisions	0
LOCK	Lock list escalations	0
LOCK	Lock list inserted row   entries	21
LOCK	Lock list inserted table entries	21
LOCK	Detected deadlocks	0
LOCK	Request timeouts	0
LOG	Log page physical reads	0
LOG	Log page physical writes	0
LOG	Log queue pages	50
LOG	Log queue max used pages	0
LOG	Log queue inserts	0
LOG	Log queue overflows	0
LOG	Log queue group commits	0
LOG	Log queue waits for log page write	0
LOG	Log queue max waits per log page	0
LOG	Log queue avg waits per log page	0
LONG	BD read   LONG	0
LONG	BD write  LONG	0
PAGES	Virtual  reads	2250
PAGES	Virtual  writes	1116
PAGES	Physical reads	29
PAGES	Physical writes	0
PAGES	Catalog        virtual  reads	192
PAGES	Catalog        virtual  writes	0
PAGES	Catalog        physical reads	22
PAGES	Catalog        physical writes	0
PAGES	Perm page      virtual  reads	100
PAGES	Perm page      virtual  writes	0
PAGES	Perm page      physical reads	7
PAGES	Perm page      physical writes	0
PAGES	Temp page      virtual  reads	1958
PAGES	Temp page      virtual  writes	1116
PAGES	Temp page      physical reads	0
PAGES	Temp page      physical writes	0
PAGES	LONG page      virtual  reads	0
PAGES	LONG page      virtual  writes	0
PAGES	LONG page      physical reads	0
PAGES	LONG page      physical writes	0
PAGES	Leaf page      virtual  reads	1397
PAGES	Leaf page      virtual  writes	1086
PAGES	Leaf page      physical reads	29
PAGES	Leaf page      physical writes	0
PAGES	Level1 page    virtual  reads	853
PAGES	Level1 page    virtual  writes	30
PAGES	Level1 page    physical reads	0
PAGES	Level1 page    physical writes	0
PAGES	Level2 page    virtual  reads	0
PAGES	Level2 page    virtual  writes	0
PAGES	Level2 page    physical reads	0
PAGES	Level2 page    physical writes	0
PAGES	Level3 page    virtual  reads	0
PAGES	Level3 page    virtual  writes	0
PAGES	Level3 page    physical reads	0
PAGES	Level3 page    physical writes	0
PAGES	Level4 page    virtual  reads	0
PAGES	Level4 page    virtual  writes	0
PAGES	Level4 page    physical reads	0
PAGES	Level4 page    physical writes	0
PAGES	Level5 page    virtual  reads	0
PAGES	Level5 page    virtual  writes	0
PAGES	Level5 page    physical reads	0
PAGES	Level5 page    physical writes	0
PAGES	Converter page virtual  reads	0
PAGES	Converter page virtual  writes	0
PAGES	Converter page physical reads	0
PAGES	Converter page physical writes	0
ROW	BD add  record perm	0
ROW	BD add  record temp	978
ROW	BD repl record perm	0
ROW	BD repl record temp	0
ROW	BD del  record perm	0
ROW	BD del  record temp	21
ROW	BD get  record perm	122
ROW	BD get  record temp	62
ROW	BD next record perm	0
ROW	BD next record temp	63
ROW	BD prev record perm	0
ROW	BD prev record temp	1
ROW	BD select direct record	5
ROW	BD select next   record	65
ROW	BD select prev   record	0
ROW	BD add to   index list perm	0
ROW	BD add to   index list temp	0
ROW	BD del from index list perm	0
ROW	BD del from index list temp	0
ROW	BD get      index list perm	0
ROW	BD get      index list perm parallel	0
ROW	BD get      index list temp	0
TRANS	SQL commands	189
TRANS	Write transactions	0
TRANS	KB calls	276
OBJECT	OMS version unloads	0
REWRITE	EliminateOrderBy	0
REWRITE	MergeFromSelectOrView	0
REWRITE	MergeExistentialSubquery	0
REWRITE	ConvertExistentialSubquery	0
REWRITE	ConvertToExistentialSubquery	0
REWRITE	DistinctPullUp	0
REWRITE	DistinctPushDownTo	0
REWRITE	DistinctPushDownFrom	0
REWRITE	DistinctForSubqueries	0
REWRITE	OptimizeSubqueries	0
REWRITE	SimplifyPredicates	0
REWRITE	EliminateGroupByOrDistinct	0
REWRITE	PushDownPredicates	0
REWRITE	PushDownProjection	0
REWRITE	PushDownQuantifier	0
REWRITE	MergeFromSelectOrView	0
REWRITE	MergeExistentialSubquery	0
REWRITE	ConvertExistentialSubquery	0
REWRITE	ConvertToExistentialSubquery	0
REWRITE	DistinctPullUp	0
REWRITE	DistinctPushDownTo	0
REWRITE	DistinctPushDownFrom	0
REWRITE	DistinctForSubqueries	0
REWRITE	OptimizeSubqueries	0
REWRITE	SimplifyPredicates	0
REWRITE	EliminateGroupByOrDistinct	0
REWRITE	PushDownPredicates	0
REWRITE	PushDownProjection	0
REWRITE	PushDownQuantifier	0

[Former Member]

NEW SERVER:

TYPE	DESCRIPTION	VALUE
CACHES	Data cache accesses	703
CACHES	Data cache accesses successful	677
CACHES	Data cache accesses unsuccessful	26
CACHES	Data cache hit rate (%)	96
CACHES	Catalog cache accesses	858
CACHES	Catalog cache accesses successful	732
CACHES	Catalog cache accesses unsuccessful	126
CACHES	Catalog cache hit rate (%)	85
CACHES	Sequence cache accesses	0
CACHES	Sequence cache accesses successful	0
CACHES	Sequence cache accesses unsuccessful	0
CACHES	Sequence cache hit rate (%)	0
CACHES	Data cache sqlpage accesses	703
CACHES	Data cache sqlpage accesses successful	677
CACHES	Data cache sqlpage accesses unsuccessful	26
CACHES	Data cache sqlpage hit rate(%)	96
CACHES	Data cache OMS accesses	0
CACHES	Data cache OMS accesses successful	0
CACHES	Data cache OMS accesses unsuccessful	0
CACHES	Data cache OMS hit rate (%)	0
CACHES	Data cache OMS log accesses	0
CACHES	Data cache OMS log accesses successful	0
CACHES	Data cache OMS log accesses unsuccessful	0
CACHES	Data cache OMS log hit rate (%)	0
CACHES	Data history/undo accesses	0
CACHES	Data history/undo accesses successful	0
CACHES	Data history/undo accesses unsuccessful	0
CACHES	Data history/undo hit rate (%)	0
CACHES	Data cache no of SQL data pages	102
CACHES	Data cache no of OMS data pages	0
CACHES	Data cache no of history/undo pages	0
CACHES	Data cache no of unloaded version pages	0
LOAD	Seconds since last init	41
LOAD	SQL commands	217
LOAD	PREPAREs	36
LOAD	PREPAREs repeated	3
LOAD	EXECUTEs	66
LOAD	COMMITs	2
LOAD	ROLLBACKs	4
LOAD	LOCKs and UNLOCKs	0
LOAD	SUBTRANS BEGINs	0
LOAD	SUBTRANS ENDs	0
LOAD	SUBTRANS ROLLBACKs	0
LOAD	CREATEs	1
LOAD	ALTERs	0
LOAD	DROPs	0
LOAD	SELECTs and FETCHes	62
LOAD	SELECTs and FETCHes, rows read	573
LOAD	SELECTs and FETCHes, rows qual	171
LOAD	INSERTs	1
LOAD	INSERTs, rows inserted	0
LOAD	UPDATEs	2
LOAD	UPDATEs, rows read	21
LOAD	UPDATEs, rows updated	1
LOAD	DELETEs	0
LOAD	DELETEs, rows read	0
LOAD	DELETEs, rows deleted	0
LOAD	Internal DBPROC calls	20
LOAD	External DBPROC calls	0
LOAD	Internal trigger calls	0
LOAD	External trigger calls	0
LOAD	Primary key accesses	0
LOAD	Primary key accesses (IN strategy)	0
LOAD	Primary key accesses (SUBQ strategy)	0
LOAD	Primary key accesses, rows read	0
LOAD	Primary key accesses, rows qual	0
LOAD	Primary key range accesses	4
LOAD	Primary key range accesses, rows read	4
LOAD	Primary key range accesses, rows qual	4
LOAD	Index accesses	0
LOAD	Index accesses (IN strategy)	0
LOAD	Index accesses (SUBQ strategy)	0
LOAD	Index scan	0
LOAD	Index accesses, rows read	0
LOAD	Index accesses, rows qual	0
LOAD	Index range accesses	0
LOAD	Index range accesses, rows read	0
LOAD	Index range accesses, rows qual	0
LOAD	Isolated index accesses	0
LOAD	Isolated index accesses (IN strategy)	0
LOAD	Isolated index accesses (SUBQ strategy)	0
LOAD	Isolated index accesses, rows read	0
LOAD	Isolated index accesses, rows qual	0
LOAD	Isolated index range accesses	0
LOAD	Isolated index range accesses, rows read	0
LOAD	Isolated index range accesses, rows qual	0
LOAD	Table scans	29
LOAD	Table scans, rows read	506
LOAD	Table scans, rows qual	120
LOAD	Isolated index scans	0
LOAD	Isolated index scans, rows read	0
LOAD	Isolated index scans, rows qual	0
LOAD	Memory sorts / sort&merge	0
LOAD	Memory sorts / sort&merge, rows read	0
LOAD	Sorts by insertion	23
LOAD	Sorts by insertion, rows inserted	87
LOAD	Join via Hash	0
LOAD	Hash join failed because of memory	0
LOAD	Hash join failed because of small buffer	0
LOAD	Join via parallel index read	0
LOAD	Join via standard algorithm	0
LOAD	Join via operator algorithm	6
LOCK	Lock list avg used entries	0
LOCK	Lock list max used entries	2400
LOCK	Lock list collisions	0
LOCK	Lock list escalations	0
LOCK	Lock list inserted row   entries	26
LOCK	Lock list inserted table entries	26
LOCK	Detected deadlocks	0
LOCK	Request timeouts	0
LOG	Log page physical reads	0
LOG	Log page physical writes	0
LOG	Log queue pages	50
LOG	Log queue max used pages	0
LOG	Log queue inserts	0
LOG	Log queue overflows	0
LOG	Log queue group commits	0
LOG	Log queue waits for log page write	0
LOG	Log queue max waits per log page	0
LOG	Log queue avg waits per log page	0
LONG	BD read   LONG	0
LONG	BD write  LONG	0
PAGES	Virtual  reads	677
PAGES	Virtual  writes	226
PAGES	Physical reads	226
PAGES	Physical writes	0
PAGES	Catalog        virtual  reads	180
PAGES	Catalog        virtual  writes	0
PAGES	Catalog        physical reads	128
PAGES	Catalog        physical writes	0
PAGES	Perm page      virtual  reads	124
PAGES	Perm page      virtual  writes	0
PAGES	Perm page      physical reads	98
PAGES	Perm page      physical writes	0
PAGES	Temp page      virtual  reads	373
PAGES	Temp page      virtual  writes	226
PAGES	Temp page      physical reads	0
PAGES	Temp page      physical writes	0
PAGES	LONG page      virtual  reads	0
PAGES	LONG page      virtual  writes	0
PAGES	LONG page      physical reads	0
PAGES	LONG page      physical writes	0
PAGES	Leaf page      virtual  reads	578
PAGES	Leaf page      virtual  writes	226
PAGES	Leaf page      physical reads	26
PAGES	Leaf page      physical writes	0
PAGES	Level1 page    virtual  reads	99
PAGES	Level1 page    virtual  writes	0
PAGES	Level1 page    physical reads	0
PAGES	Level1 page    physical writes	0
PAGES	Level2 page    virtual  reads	0
PAGES	Level2 page    virtual  writes	0
PAGES	Level2 page    physical reads	0
PAGES	Level2 page    physical writes	0
PAGES	Level3 page    virtual  reads	0
PAGES	Level3 page    virtual  writes	0
PAGES	Level3 page    physical reads	0
PAGES	Level3 page    physical writes	0
PAGES	Level4 page    virtual  reads	0
PAGES	Level4 page    virtual  writes	0
PAGES	Level4 page    physical reads	0
PAGES	Level4 page    physical writes	0
PAGES	Level5 page    virtual  reads	0
PAGES	Level5 page    virtual  writes	0
PAGES	Level5 page    physical reads	0
PAGES	Level5 page    physical writes	0
PAGES	Converter page virtual  reads	0
PAGES	Converter page virtual  writes	0
PAGES	Converter page physical reads	0
PAGES	Converter page physical writes	0
PAGES	Clustered virtual reads	0
PAGES	Clustered page virtual reads	0
PAGES	Pages marked for reclustering	0
PAGES	Cluster compression segment reads	167
PAGES	Cluster compression block reads	214
PAGES	Cluster compression pages handled	200
ROW	BD add  record perm	6
ROW	BD add  record temp	174
ROW	BD repl record perm	0
ROW	BD repl record temp	0
ROW	BD del  record perm	0
ROW	BD del  record temp	21
ROW	BD get  record perm	119
ROW	BD get  record temp	56
ROW	BD next record perm	0
ROW	BD next record temp	84
ROW	BD prev record perm	0
ROW	BD prev record temp	1
ROW	BD select direct record	4
ROW	BD select next   record	74
ROW	BD select prev   record	0
ROW	BD add to   index list perm	0
ROW	BD add to   index list temp	0
ROW	BD del from index list perm	0
ROW	BD del from index list temp	0
ROW	BD get      index list perm	0
ROW	BD get      index list perm parallel	0
ROW	BD get      index list temp	0
TRANS	SQL commands	153
TRANS	Write transactions	0
TRANS	KB calls	204
OBJECT	OMS version unloads	0
REWRITE	EliminateSubqueries	0
REWRITE	OptimizeSubqueries	0
REWRITE	SimplifyPredicates	0
REWRITE	EliminateOrderBy	0
REWRITE	EliminateGroupByOrDistinct	0
REWRITE	RemoveConstFromGroupOrOrderBy	0
REWRITE	MergeFromSelectOrView	0
REWRITE	MergeExistentialSubquery	0
REWRITE	ConvertExistentialSubquery	0
REWRITE	ConvertToExistentialSubquery	0
REWRITE	DistinctPullUp	1
REWRITE	DistinctForSubqueries	0
REWRITE	DistinctPushDownTo	0
REWRITE	DistinctPushDownFrom	0
REWRITE	PushDownPredicates	0
REWRITE	PushDownProjection	0
REWRITE	PushDownQuantifier	0
REWRITE	ConvertOrToIn	0
REWRITE	NormalizePredicates	0
REWRITE	AddLocalPredicates	0
REWRITE	AddLocalPredicates	0