FYI.
Alex Tomita NONLILLY
03/12/2002 05:53 p.m.
To: [EMAIL PROTECTED]
cc:
Subject: Re: SAPDB Performance Question
This is the explain plan:
OWNER TABLENAME COLUMN_OR_INDEX STRATEGY
PAGECOUNT O D T M
ADMIN MASTERF TABLE SCAN 6122
ADMIN TXTMASTER ITXTMASTER JOIN VIA RANGE OF
MULTIPLE INDEXED COL. 32916
PAPROPAC (USED INDEX
COLUMN)
ADMIN RESULT IS COPIED , COSTVALUE IS 71886
as you see the table TXTMASTER has a lot of data (aprox. 2'000 000) and
the MASTERF has aprox. 1000...
This is the select statement:
explain
SELECT
ADMIN.TXTMASTER.YEARMONTH,
ADMIN.TXTMASTER.USD,
ADMIN.TXTMASTER.PACK,
ADMIN.TXTMASTER.DT,
ADMIN.MASTERF.L1C,ADMIN.MASTERF.L1D,
ADMIN.MASTERF.L2C,ADMIN.MASTERF.L2D,ADMIN.MASTERF.L3C,
ADMIN.MASTERF.L3D,ADMIN.MASTERF.L4C,ADMIN.MASTERF.L4D,ADMIN.MASTERF.L5C,
ADMIN.MASTERF.L5D,ADMIN.MASTERF.L6C,ADMIN.MASTERF.L6D,ADMIN.MASTERF.L7C,
ADMIN.MASTERF.L7D,ADMIN.MASTERF.L8C,ADMIN.MASTERF.L8D,ADMIN.MASTERF.L9C,
ADMIN.MASTERF.L9D,
ADMIN.MASTERF.LILLYMARKET,
ADMIN.MASTERF.COUNTRY,
ADMIN.MASTERF.L7X,
ADMIN.MASTERF.MOLECULE
FROM ADMIN.TXTMASTER,ADMIN.MASTERF
WHERE TXTMASTER.PAPROPAC= MASTERF.PAPROPAC
after that I made the insert statement something like this " insert
into tableC ( the select statement.....) "..
with the pagecount equals to 71886, is this a lot of I/O ??..
thanks very much..
Alex
[EMAIL PROTECTED]
03/12/2002 03:29 p.m.
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: SAPDB Performance Question
Hi,
>ok I did that, but what is the meaning of the PAGECOUNT
>column that EXPLAIN showed me..??
"Result of the cost determination for a search strategy". The number of
pages the database has to process to do a certain operation. Check this
document http://www.sapdb.org/pdf/optim_73eng.pdf.
Also, email the whole plan here.
Regards,
Wojtek
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
