Skip to main content

Creating Indexes and Database Diagramming

  • Chapter
  • First Online:
Book cover Beginning SQL Server for Developers
  • 2181 Accesses

Abstract

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 54.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 69.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2015 Robin Dewson

About this chapter

Cite this chapter

Dewson, R. (2015). Creating Indexes and Database Diagramming. In: Beginning SQL Server for Developers. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-0280-7_6

Download citation

Publish with us

Policies and ethics