Home » RDBMS Server » Performance Tuning » Oracle Schema slowing performance
Oracle Schema slowing performance [message #118367] Wed, 04 May 2005 13:41 Go to next message
ravin
Messages: 3
Registered: May 2005
Location: uk
Junior Member
Hi,
I want to know, whether defining a Schema and using it slows down the performance of Select SQL?
Re: Oracle Schema slowing performance [message #118375 is a reply to message #118367] Wed, 04 May 2005 15:17 Go to previous messageGo to next message
smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida
Senior Member
Can you elaborate a bit more on your question? What do you mean?
Re: Oracle Schema slowing performance [message #118420 is a reply to message #118367] Thu, 05 May 2005 02:07 Go to previous messageGo to next message
ravin
Messages: 3
Registered: May 2005
Location: uk
Junior Member
using the schema is slowing down the performance.....
Re: Oracle Schema slowing performance [message #118434 is a reply to message #118367] Thu, 05 May 2005 04:05 Go to previous messageGo to next message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Do you mean to ask whether there is a difference in performance between these two statements ?
select ename
from   emp
where  empno = :1

or

select ename
from   scott.emp
where  empno = :1


If that is your question, then the answer is no. There is no performance loss in using schema prefixes.

hth
Re: Oracle Schema slowing performance [message #118439 is a reply to message #118434] Thu, 05 May 2005 04:40 Go to previous messageGo to next message
ravin
Messages: 3
Registered: May 2005
Location: uk
Junior Member
hi,
I have requested our DBA team to create a Synonym , so that we do not have to prefix schema name. DBA team has come back to me, saying creating Synonym would slow down the perfromance.
I am not able to digest this comment from our DBA eam. hence I wanted to check whether there is performance issue with schema name or not?
ravi
Re: Oracle Schema slowing performance [message #118462 is a reply to message #118367] Thu, 05 May 2005 07:31 Go to previous messageGo to next message
tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore
Junior Member

hi

this not making any sence ya u check out again what the people saying and reply back.

Thanks.
Re: Oracle Schema slowing performance [message #118463 is a reply to message #118367] Thu, 05 May 2005 07:32 Go to previous messageGo to next message
tycoonajayverma
Messages: 17
Registered: May 2005
Location: b'lore
Junior Member

hi all,

If this is the case those people saying this same one what u thing..?????????

Thanks
Re: Oracle Schema slowing performance [message #118867 is a reply to message #118367] Mon, 09 May 2005 08:06 Go to previous messageGo to next message
Satheesh Babu.S
Messages: 35
Registered: July 2004
Member
Yes there is a overhead when using synonyms. If you can use with schema_name.object_name, then please use it. This approach is better than private synonym and very much better than public synonym.

Thanks and Regards,
Satheesh Babu.S
Bangalore.
Re: Oracle Schema slowing performance [message #118872 is a reply to message #118439] Mon, 09 May 2005 08:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://www.ixora.com.au/newsletter/2001_05.htm
Re: Oracle Schema slowing performance [message #118916 is a reply to message #118367] Mon, 09 May 2005 12:23 Go to previous message
Frank
Messages: 7901
Registered: March 2000
Senior Member
Ah, but this is the other way around then your initial question. I understood that question as does using explicit schema-names slow down performance...

Sorry for the misleading answer then.
Previous Topic: Query takes long time -need help to improve Performance
Next Topic: Cursor Performance Issue
Goto Forum:
  


Current Time: Tue Mar 19 02:37:58 CDT 2024