remote dba support
More
    HomeSql TutorialYou should maintain your sql statement identical

    You should maintain your sql statement identical

    I am starting this new section called SQL tutorial. This section doesn’t contain only basic SQL statement written learning, but it also contains some guidance and advice from my experience. SQL is sometimes called as sequel. Don’t bother!

    Always use SQL writing pattern identical. It means you need to use your writing style pattern, unique or the same type repeatedly.

    - Advertisement -
    dbametrix

    Take an example:

    select * from emp;

    SELECT * from emp;

    - Advertisement -
    dbametrix

    select * from EMP;

    select * FROM emp;

    SELECT * FROM EMP;

    SELECT * from EMP;

    SELECT * FROM emp;

    Select * from Emp;

    All are the same kind of statements. Looking wise, all are the same. The result of the above statement is also the same, but the System Global Area of Oracle memory treats all statements differently. Thus, the above-all statements will be parsed separately and occupy memory separately.  The problem starts with those SQL statements which are written in a different manner.

    This is the only example. In real-time, if you check your long SQL statements and guess how it will be stored in the Oracle SGA memory region? Those long and big SQL statements will consume so much memory in the Oracle SQL engine. The resulting memory is wastage and unnecessary parsing. Hard parsing always consumes high CPU and SQL statements will consume memory. It means so many performance issues can be occurring due to this bad practice.

    I have seen lots of developers and programmer who has their own pattern of SQL statement writing. But when you are changing the company and joining a new company then you should need to observe this thing first for keeping your mind which writing pattern is being followed by your company’s old employee. Or as the project manager, IT manager, you need to develop your own skill and fix the pattern of the Structured Query Language writing method. An example, you can keep all table names in uppercase and the rest of them in lower cases. You can keep it all in lowercase.

    Therefore, avoid this kind of silly mistake before you are starting to write a new SQL statement in your company.

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert.

    This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. All Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    - Advertisement -
    dbametrix
    - Advertisment -
    remote dba services

    Most Popular