C H A P T E R  6

Creating Indexes and Database Diagramming

Now that you have created the tables, you could stop at this point and just work with the data from here. However, this would not be a good decision. As soon as any table contained a reasonable amount of information, and you wished to find a particular record, it would take SQL Server a fair amount of time to locate it. Performance would suffer, and your users would soon get annoyed with the slowdown in speed.

In this scenario, the database is like a large filing cabinet in which you have to find one piece of paper, but there’s no clear filing system or form of indexing. If there were some sort of cross-reference facility, then it would likely be easier to find the information that ...

Get Beginning SQL Server 2012 for Developers now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.