• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Adding Indexes

Creating indexes in a table allows for faster access to the information in the table when it is being queried, much the same way that you use the index in this book—you find the term you want and jump directly to the pages containing that term. You don’t have to leaf through all the pages to find the information you are looking for.

Similar to an Access desktop database, SQL Server implements the primary key by creating an index on it. As noted earlier, you must define a primary key to be able to update an SQL Server table from your Access project. You must also define primary keys for your tables to be able to create relationships between tables.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint