Chapter 6. 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 wanted to find a particular record, it would take SQL Server Express a fair amount of time to locate it. Performance would suffer, and our users would soon get annoyed with the slowdown in speed.
In this scenario, the database is like a large filing cabinet in which we have to find one piece of paper, but there's no clear filing system or form of indexing. If we had some sort of cross-reference facility, it would likely be easier to find the information we need. And if that cross-reference ...
Get Beginning SQL Server 2008 Express for Developers: From Novice to Professional 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.
