REPOST: Re: synonym

Sorry, I didn't write a version.
Oracle 7.3.4.5
HP-UX 10.20

"Mario" <mario.jaksic_at_zg.tel.hr> wrote in message news:a2v0l8$2vk6$1_at_as201.hinet.hr...
> 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.
>
>
>
>
>
>

• WAS CANCELLED BY =======: From: "Mario" <mario.jaksic_at_zg.tel.hr> Control: cancel <a2v176$9mld$1_at_as201.hinet.hr> Subject: cmsg cancel <a2v176$9mld$1_at_as201.hinet.hr> Date: Mon, 28 Jan 2002 00:48:47 GMT Message-ID: <cancel.a2v176$9mld$1_at_as201.hinet.hr> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!nerim.net!feed.ac-versailles.fr!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40720754

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Sat Jan 26 2002 - 13:52:31 CST