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?

1. server * 2^32 + ticket (a numeric composition of the two keys)
2. server & " " & ticket (a string concatenation of the two attributes)
3. Somthing entirely different

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?

1. server * 2^32 + ticket (a numeric composition of the two keys)
2. server & " " & ticket (a string concatenation of the two attributes)
3. Something entirely different