CHAPTER 6

image

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

Get Beginning SQL Server for Developers, Fourth Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.