| Oracle SQL statements Case sensitive for Performance? [message #65209] |
Mon, 14 June 2004 13:41  |
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  |
 |
Mahesh Rajendran
Messages: 10708
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
