O'Reilly logo

Beginning SQL Server 2008 Express for Developers: From Novice to Professional by Robin Dewson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required