Defining column constraints

Column constraints enforce limits on the data or types of data that can be inserted/updated/deleted from a table. The whole purpose of constraints is to maintain the data integrity during an UPDATE/DELETE/INSERT into a table. However, we should only define constraints where appropriate; otherwise, we will create a negative impact on performance. For example, defining NOT NULL constraints does not impose noticeable overhead during query processing, but defining CHECK constraints might create a negative effect on performance.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset