synonym

Hi!
Can someone give me an explanation what's wrong in this picture? If I make (like ownerA):
select col1, col3 from <ownerB>.<viewB> where col2 = <number> then Oracle uses indexes.
But, if I make:
select col1, col3 from <synonymA> where col2 = <number> Oracle skips one of the indexes and makes full table scan.

<synonymA> -> <ownerB.viewB>
ViewB is "select from three tables"

TIA,
Mario. Received on Sat Jan 26 2002 - 13:42:06 CST