Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: explain plan differences...
A possible indicator of this comes from the lines:
>> 10 3 TABLE ACCESS (BY INDEX ROWID) OF 'TBL_ANGEBOT'
(Cost=1 Card=2049 Bytes=26637)
>> 12 2 TABLE ACCESS (BY INDEX ROWID) OF 'TBL_ANGEBOT'
(Cost=1 Card=2196 Bytes=28548)
The expected number of rows returned (card) is larger in one plan than the other. This may be because the access has appeared in a different place in the place, but it may simply mean that the statistics after the exp/imp are slightly different.
-- Jonathan Lewis http://www.jlcomp.demon.co.uk Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. Connor McDonald wrote in message <3C2104E9.1E4E_at_yahoo.com>...Received on Thu Dec 20 2001 - 04:15:55 CST
>
>When you exp/imp, the second schema will have rows more tightly packed,
>indexes freshly built et al - if the stats reflect this, then the plans
>could be different.
>
![]() |
![]() |