2 ms·
I wonder: are there any good rules-of-thumb for when to go ahead and add indices at table-creation time?
by glhaynes 15y ago
I wonder: are there any good rules-of-thumb for when to go ahead and add indices at table-creation time?
- emmett 15y agoProjected usage. It can be done, but you have to be an expert basically.
- BrentOzar 15y agoAdd an index to support foreign key relationships. If you've got a SalesHeader table and a SalesDetail table, you want an index on SalesDetail.SalesHeaderID, especially if you allow cascading deletes from the SalesHeader table.