Home » RDBMS Server » Performance Tuning » Performance gain in qualifying the owner of a table when querying?
Performance gain in qualifying the owner of a table when querying? [message #65083] Thu, 22 April 2004 14:34 Go to next message
Oradeveloper
Messages: 1
Registered: April 2004
Junior Member
In a stored proc, when you query data, is there
a performance gain when you actually qualify the
owner of the table ? If so how much ?

I probably agree that there is a gain b/c Oracle probably
takes less time searchin in the dictionary. But I was told (by a DBA) that I can gain as much as 10 to 15 % in performance if I qualify the owner name?

Does that sound reasonable or far fetched?

PROCEDURE FOO ()
AS

BEGIN
SELECT column1 INTO variable1
FROM owner_name.TableName
WHERE .... ;

END
Re: Performance gain in qualifying the owner of a table when querying? [message #65085 is a reply to message #65083] Thu, 22 April 2004 22:18 Go to previous message
dieter
Messages: 17
Registered: February 2002
Junior Member
some years ago we have done some performance testing with oracle 8 and actually also came to a performance gain of 10-20%. we also got some feedback from oracle that confirmed this performance difference. it would be actually interesting knowing if things changed in the current versions of oracle.

-dieter

info@materialdreams.com
www.materialdreams.com
Previous Topic: problem installation
Next Topic: Oracle server Ram Upgrade
Goto Forum:
  


Current Time: Sun Sep 20 16:20:13 CDT 2020