| Performance gain in qualifying the owner of a table when querying? [message #65083] |
Thu, 22 April 2004 14:34  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
