rdbms - Why use primary keys? -


Identifying a unique column in the table uses a different primary key? Can not this be done on one column only using an autoimmune block? I understand that PK and FK are used to relate to different tables, but can it be done only by joining?

> For the integrity referenced with most foreign keys, when you have a PK, it will also create an indicator behind the scenes and in this way you do not need a table scan in search of values ​​


Comments

Popular posts from this blog

.net - C# List<T>.Find(x=>x.Rectangle.Contains(Point)) FAIL -

iphone - Smoothing a rounded stroke in Core Graphics -

c++ - QtQuick: QQmlApplicationEngine failed to load component qrc:/main.qml:23 Invalid attached object assignment -