March 2013 Archives

Table Indexes

Been a while since I have created a table and this came to mind as I was clearing some best practices after creating one. There is no BP check for this, but one of the most frequent complaints from DBA's and potential performance impacts we make is forgetting to leverage indexes or at least create them. It may seem parameter, temp and working tables don't really need an index, but as a rule create one for every table.

Here is an easy way to create an "if nothing else" index.


1. Set the CreateRecIdIndex to Yes
2. Save the table
3. Set the Primary and Cluster Index to RecId

-Asa

About this Archive

This page is an archive of entries from March 2013 listed from newest to oldest.

September 2010 is the previous archive.

Find recent content on the main index or look in the archives to find all content.

Pages

Powered by Movable Type 5.01