Sergiy (7/18/2014)
Koen Verbeeck (7/17/2014)
Sergiy (7/16/2014)
Koen Verbeeck (7/16/2014)
So it is 100% possible to decouple the primary key from the indexCan you illustrate how?
Easy peasy. I draw a table diagram in Visio and declare the combination of a few columns to be the primary key.
(in other words, I am creating the logical design)
Where do you see an index?
I do not see a primery key here either.
I do not even see a database.
It's just a set of drawings, labels, indicated intentions.
As soon you try to turn it into an actual database and actually create that PK the corresponding index will be there.
You appear to be suggesting that a primary key does not and can not exist unless it is physically implemented in a database - is that the case?
Meaning, presumably, that you object to a basic database design document using the term 'primary key'.
Perhaps instead you refer to a relation's "default unique-row identifier(s)". Does the job, I suppose.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.