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
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
