Home » RDBMS Server » Performance Tuning » Oracle SQL statements Case sensitive for Performance?
Oracle SQL statements Case sensitive for Performance? [message #65209] Mon, 14 June 2004 13:41 Go to next message
kris
Messages: 43
Registered: February 2002
Member
Hello.

I would like to know if Oracle distinguishes SQL statements based on case.

For eg. will the following statements compiled separately within Oracle?

SELECT * FROM USER

and

select * from user

What will be the performance impact?

Thanks,

Kris
Re: Oracle SQL statements Case sensitive for Performance? [message #65213 is a reply to message #65209] Tue, 15 June 2004 03:49 Go to previous message
Mahesh Rajendran
Messages: 10694
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Both the statements get diffent parse-codes.
so
if you execute statement1 and let the parsecode is xxa1.
if u execute the same statement again, oracle will NOT parase the statement.
but when you execute the statement2 there will a full parse and another parse-code is generated.
Previous Topic: urgent- How to find invalid objects in oracle
Next Topic: Batch Job performance.
Goto Forum:
  


Current Time: Tue Sep 22 07:40:32 CDT 2020