Home » RDBMS Server » Server Administration » PL/SQL vs. SQL*Plus explain plans
PL/SQL vs. SQL*Plus explain plans [message #369770] Fri, 06 October 2000 11:41 Go to next message
Tom Hall
Messages: 1
Registered: October 2000
Junior Member
I have noted significant differences in performance of the same SELECT statement in PL/SQL and SQL*Plus. When I look at the explain plans for both the SQL*Plus and PL/SQL forms of the SELECT, they are different. Why is this? (Oracle rdbms v7.3.4.2.0 on AIX) Is there a different optimizer being used for PL/SQL?

Report message to a moderator

Re: PL/SQL vs. SQL*Plus explain plans [message #369773 is a reply to message #369770] Fri, 06 October 2000 19:19 Go to previous message
Andrew again...
Messages: 270
Registered: July 2000
Senior Member
I have noticed similar diferences too, and just forced the execution with a hint in PL/SQL.

One obvious thing to check is that the optimizer mode is not being changed in one of your environments.

Report message to a moderator

Previous Topic: Package Body
Next Topic: I found it "You cannot create a trigger on table in the schema SYS."
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 28 10:46:58 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.