Creating Indexes and Database Diagramming
Now that we’ve created the tables, we could stop at this point and just work with our data from here. However, this would not be a good decision. As soon as any table contained a reasonable amount of information, and we wished to find a particular record, it would take SQL Server a fair amount of time to locate it. Performance would suffer, and our users would soon get annoyed with the slowdown in speed.
KeywordsUnique Index Query Plan Sort Order Transaction Type File Group
Unable to display preview. Download preview PDF.