I let's say I have the following table:
Create Table Orders(server : tiny int, ticket : integer, primary key (server, ticket));
How is the composite primary key representation when stored on disk?
server * 2^32 + ticket
(a numeric composition of the two keys)server & " " & ticket
(a string concatenation of the two attributes)- Somthing entirely different