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


About this Entry

This page contains a single entry by AsA published on March 12, 2013 9:11 PM.

Visitors was the previous entry in this blog.

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


Powered by Movable Type 5.01