ok I did that, but what is the meaning of the PAGECOUNT column that
EXPLAIN showed me..??
thanks
[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
03/12/2002 03:09 p.m.
To: [EMAIL PROTECTED]
cc: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: SAPDB Performance Question
Hi,
I would start from using EXPLAIN <your select here>.
>had created an INDEX on tableA with the ID Column but
>it seems that it doesn't help too much.
I guess you need an index on both join columns. Check out what EXPLAIN
will
tell you.
Regards,
Wojtek
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
