cardinality in plans
ExorOct 27 2009 — edited Oct 28 2009Hello,
Can some one please explain to me what can cause the fact that for the same query, the owner of the objects (tables) and a user with just select rights show different cardinalities in the explain plan?
So user a owns all the tables and the views:
connect a/a
select * from myview;
show cardinality for table t1 referenced in the view 100k.
connect a_read/a_ared
select * from a.myview
show cardinality for table a.t1 referenced in the view 100k.
user a_read doesn't own any objects at all.
Thank you,