Quick steps: Creating indexes using the Enterprise Manager

Learn to create indexes using the Enterprise Manager in this book excerpt from MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation.

The following excerpt, courtesy of Que Certification, is from Chapter 10 of the book MCAD/MCSD/MCSE Training Guide (70-229): SQL Server 2000 Database Design and Implementation by Thomas Moore and Ed Tittel. Click for the complete book excerpt series or purchase the book.



STEP BY STEP - 10.2

Creating indexes using the Enterprise Manager


  1. Open the SQL Server Enterprise Manager; expand a server group and then expand a server.

  2. Expand Databases; expand the database in which you want to create your table.

  3. Right-click Tables, and then click New Table.

  4. In the Choose Name dialog box, enter a name for the table.

  5. Fill in the columns as appropriate. Each row represents one column in the table.

  6. Right-click any row; then click Properties.

  7. On the Indexes/Keys tab, click New.

  8. In the Column Name list, click the columns that are part of the index.

  9. In the Index Name text box, enter a name for the index.

  10. In Index file group, select a file group on which to create the index.

  11. Select Create UNIQUE to make this index a unique constraint. Or click Index to make this index unique.

  12. Select Create As CLUSTERED to make this index clustered.

  13. In Fillfactor, specify how full SQL Server should make the leaf level of each index page during index creation. Fillfactor is covered later in the chapter.


Click for the complete book excerpt series.

This was first published in January 2006

Dig deeper on SQL Server Database Modeling and Design

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchDataCenter

SearchDataManagement

SearchAWS

SearchOracle

SearchContentManagement

SearchWindowsServer

Close