Tuesday, July 4, 2017
PLSQL Performance Tuning – NOT NULL Constraint
In
this post, I tried to explain the importance of constraint “NOT NULL” from
performance perspective.
From SQL Perspective:
- It adds semantic meaning to your data model. You KNOW that the column will always contain a value.
- It removes ambiguity.
- The more information you give the database, the better the quality of the plans. Not null impacts the optimizer, query rewrite, even the queries you must type in to get the correct answer.
- It improves Query Performance
From PLSQL Perspective: Its
better to use “NOT NULL” has a slight edge towards performance. The below demonstration will explain the same.
Demonstration:
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
3 Responses to “PLSQL Performance Tuning – NOT NULL Constraint”
December 29, 2018 at 9:28 PM
Thanks and Regards. Oracle Apps R12 Training Videos at affordable cost. please check oracleappstechnical.com
July 15, 2019 at 12:59 AM
I am unable to read articles online very often, but I’m glad I did today. This is very well written and your points are well-expressed. Please, don’t ever stop writing. Abschleppen Hamburg
June 4, 2020 at 5:11 AM
Your blog provided us with valuable information to work with. Each & every tips of your post are awesome. Thanks a lot for sharing. Keep blogging.. buy cheap instagram likes instantly
Post a Comment