Viewing 4 posts - 1 through 4 (of 4 total)
In OLTP environment, where read is more frequent than write, the Cluster index is your biggest gun and your major weapon. Over the decades its best usage is well known...
November 13, 2009 at 8:17 am
1.Size of table and growth rate.
2.Primary needed for speed of replication?
3.OLTP vs. Data Warehouse like
4.3rd normal form vs. Demoralization?
5.Contention with other servers and process?
Sometimes you may want to ask:
November 11, 2009 at 2:56 pm
The difference between hierarchy database and relational database should tell you why no one should be in that school #2.
The real 2 or 3 schools in question should have been...
November 11, 2009 at 2:13 pm
With comments like this I run for the exit:
… good clustering. One school says to put the clustered index on the column or set of columns that would be most...
November 11, 2009 at 1:51 pm