OraFAQ Forum: Performance Tuning » Pleaese clear my doubt about View and synonym having same name

Home » RDBMS Server » Performance Tuning » Pleaese clear my doubt about View and synonym having same name (UNIX 11.35)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Pleaese clear my doubt about View and synonym having same name [message #671974]

Wed, 26 September 2018 09:29

Akmmhto
Messages: 38
Registered: September 2018

Member

Suppose a db has view and synonym having same name,
Say the name is "ABC".
If I query:
Select * from ABC;

Then from where db will extract data...from view or synonym.
Is there any chances performance issue...

Thanks in advance

Report message to a moderator

[Message index]

		Pleaese clear my doubt about View and synonym having same name By: Akmmhto on Wed, 26 September 2018 09:29
		Re: Pleaese clear my doubt about View and synonym having same name By: John Watson on Wed, 26 September 2018 09:49
		Re: Pleaese clear my doubt about View and synonym having same name By: Michel Cadot on Wed, 26 September 2018 12:59
		Re: Pleaese clear my doubt about View and synonym having same name By: cookiemonster on Thu, 27 September 2018 09:43
		Re: Pleaese clear my doubt about View and synonym having same name By: cookiemonster on Thu, 27 September 2018 09:45
		Re: Pleaese clear my doubt about View and synonym having same name By: Akmmhto on Fri, 28 September 2018 12:07
		Re: Pleaese clear my doubt about View and synonym having same name By: cookiemonster on Thu, 27 September 2018 09:42

Previous Topic:	Index on order by column
Next Topic:	Transaction Isolation Level

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 23 21:29:52 CDT 2024