Are uppercase function names faster than lowercase letters in Oracle?

Question

I was just listening to dba saying that if you name all your functions, procedures, etc. in uppercase, db will work better when the workload in the database is high. It's true? I find it almost impossible to believe. Is there any benchmark or something that proves its correctness or incorrectness?

I just think this naming is relevant when reading code, especially for a command. Most likely, you can successfully modify code written in accordance with good writing conventions than just random things. But this has nothing to do with computer performance; it should be done exactly the same.

Also, if that were the case, I would not be able to call a function named FUNC as FUNC or FUNC or FUNC .

I think this statement is crazy, am I mistaken? I mean, I'm not a database expert at all, but he is dBA.

Answer 1

By default, Oracle identifiers are case insensitive. Unless you explicitly create a case-sensitive function name (by enclosing the name in double quotes) that creates many problems, none of which are performance related, Oracle will store the function name in an uppercase data dictionary.

 CREATE FUNCTION myFunction ... CREATE FUNCTION MyFuNcTiOn ... CREATE FUNCTION MYFUNCTION .. CREATE FUNCTION myfunction ... 

everyone will create a function, which in the data dictionary is called MYFUNCTION in all MYFUNCTION . You can call a function using any enclosure that makes sense to you, since it is a case-insensitive identifier. The database does not know which package you used to create the function, so it cannot affect performance.

Answer 2

The only reason you use only the names of capital entities (no more than 30 characters, by the way) is to avoid the use of quotation marks when accessing them. I have never heard of any performance impact.

If you name something FUNC , you can call it FUNC or FUNC (without quotes!) Later.

But if you call it FUNC quotes, it will be the only name you can use.