SQL Server 2000 Indexes

Overview/Description
To describe and show how to create and manage indexes

Target Audience
Database administrators, application developers, and system administrators; students preparing for Microsoft certification in installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition

Prerequisites
Experience working in a medium to enterprise computing environment that uses SQL Server 2000 Enterprise Edition; at least one years experience administering SQL Server; at least one years experience implementing relational databases in environments that contain heterogeneous databases, SQL Server security integrated with Windows Authentication, client/server configurations of 50 to 50,000 or more users, web configurations that use Internet Information Services (IIS) or COM+, databases as large as 2 TB, and multiple installations of SQL Server 2000

Expected Duration
120 Minutes

Objectives:

SQL Server 2000 Indexes

  • provide an overview of index architecture.
  • use the CREATE INDEX statement to create indexes.
  • create indexes using Enterprise Manager.
  • use Query Analyzer to create an index.
  • gather information about indexes.
  • drop, rebuild, and rename indexes.
  • rename an index using Enterprise Manager.
  • create and maintain a full text index.


    • Course Number: 31910_eng