The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
53 views

How does InnoDB represent composite integer keys?

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? ...
3
votes
0answers
72 views

Clustered index on a join table

Currently I have a table defined as follows, but I'm not sure what to cluster the table on: CREATE TABLE [Security].[UserGroups] ( [UserId] INT NOT NULL, [GroupId] INT NOT NULL, [IsAdmin] ...
0
votes
0answers
47 views

PK Guid, Clustered Indexes and Fragmentation

I need your help solving a db headache. I'm using Entity Framework as a ORM to access my database (SQL Server Azure V12), the entity model uses Guid as PK and by default SQL Server has clustered ...