4 ms·
Agreed. And certainly better than creating bad indices.
by cleaver 15y ago
Agreed. And certainly better than creating bad indices.
- glhaynes 15y agoI 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.