I suggest you ...

Clustered index not based on primary key

Might be useful for models where PK is of Guid type

28 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    AdminDmitri Maximov (Project manager, Xtensive LLC) shared this idea  ·   ·  Admin →

    3 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • kl.vlad commented  · 

        I would like to create Clustered index with
        [Index("Field", Clustered = true)]

        If there is no Index attribute with clustered - PrimaryKey should be clustered.

      • tobi commented  · 

        This is actually most useful in cases where you always query all orders for a particular customer as an example. You would then cluster the orders on (CustomerID, ID) although ID would be enough because it is unique.

      Feedback and Knowledge Base