Lisa Gardner - SQL Sever Premier FIeld Engineer

March, 2013

  • SQLGardner

    Primary Keys and the Default Clustered Index

    When it comes to determining what your clustered index should be for a given table, you often think of the primary key.  Often times that is a good choice.  In fact, that is the default is to do that.  That is not always your best choice, though, depending on how your data is being accessed.  Here I am going to show some different ways in which you can create your PK and your clustered index as well as some default behavior that you may not be aware of. When you create a table...
Page 1 of 1 (1 items)