HWZ Forums

Login Register FAQ Mark Forums Read

Need help with proposition argument

Reply
 
LinkBack Thread Tools
Old 08-06-2018, 09:20 PM   #16
Arch-Supremacy Member
 
davidktw's Avatar
 
Join Date: Apr 2010
Posts: 10,059
Another benefits of havin constraints keys in database is indexing of the data. So that query run and data will be fetch to query faster if you are dealing with huge data.
I think you need to separate between indexing and constraints. You can have indexing without constraints. So it would be not an advantage of having keys or constraints to get indexing, because the latter does not require the former.
davidktw is offline   Reply With Quote
Reply
Important Forum Advisory Note
This forum is moderated by volunteer moderators who will react only to members' feedback on posts. Moderators are not employees or representatives of HWZ. Forum members and moderators are responsible for their own posts.

Please refer to our Terms of Service for more information.


Thread Tools

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are On