• ▼MSDN Library - April 2000
  • ▶Welcome to the MSDN Library
  • ▶Visual Studio 6.0 Documentation
  • ▶Office Developer Documentation
  • ▶Windows CE Documentation
  • ▼Platform SDK
    • ▶Getting Started
    • ▶Design Strategies and Standards
    • ▶Base Services
    • ▶Component Services
    • ▼Data Access Services
      • ▶Microsoft Data Access Components (MDAC) SDK
      • ▶Jet and Replication Objects
      • ▶Microsoft XML SDK
      • ▼Microsoft SQL Server Programmer's Toolkit
        • ▶Getting Started
        • ▶What's New
        • ▶Installing SQL Server
        • ▶SQL Server Architecture
        • ▶Administering SQL Server
        • ▶Creating and Maintaining Databases
        • ▶Accessing and Changing Data
        • ▼Optimizing Database Performance
          • Overview of Optimizing Database Performance
          • ▶Database Design
          • ▼Query Tuning
            • ▼Analyzing a Query
              • Graphically Displaying the Execution Plan Using SQL Server Query Analyzer
              • ▼Logical and Physical Operators
                • Assert
                • Aggregate
                • Bookmark Lookup
                • Clustered Index Delete
                • Clustered Index Insert
                • Clustered Index Update
                • Clustered Index Scan
                • Clustered Index Seek
                • Collapse
                • Compute Scalar
                • Concatenation
                • Constant Scan
                • Cross Join
                • Delete
                • Deleted Scan
                • Distinct
                • Distinct Sort
                • Distribute Streams
                • Eager Spool
                • Filter
                • Flow Distinct
                • Full Outer Join
                • Gather Streams
                • Hash Match
                • Hash Match Root
                • Hash Match Team
                • Index Delete
                • Index Insert
                • Index Scan
                • Index Seek
                • Index Spool
                • Index Update
                • Inner Join
                • Insert
                • Inserted Scan
                • Lazy Spool
                • Left Anti Semi Join
                • Left Outer Join
                • Left Semi Join
                • Log Row Scan
                • Merge Interval
                • Merge Join
                • Nested Loops
                • Parallelism
                • Parameter Table Scan
                • Remote Delete
                • Remote Insert
                • Remote Query
                • Remote Scan
                • Remote Update
                • Repartition Streams
                • Right Anti Semi Join
                • Right Outer Join
                • Right Semi Join
                • Row Count Spool
                • Sequence
                • Sort
                • Split
                • Stream Aggregate
                • Table Delete
                • Table Insert
                • Table Scan
                • Table Spool
                • Table Update
                • Top
                • Union
                • Update
                • Cursor Logical and Physical Operators
            • Query Tuning Recommendations
            • ▶Advanced Query Tuning Concepts
          • ▶Application Design
          • ▶Optimizing Utility and Tool Performance
          • ▶Optimizing Server Performance
        • ▶Replication
        • ▶Data Transformation Services
        • ▶OLAP Services
        • ▶English Query
        • ▶Repository
        • ▶Building SQL Server Applications
        • ▶Troubleshooting
        • ▶How To
        • ▶Glossary
    • ▶Graphics and Multimedia Services
    • ▶Management Services
    • ▶Messaging and Collaboration Services
    • ▶Networking and Directory Services
    • ▶Security
    • ▶Tools and Languages
    • ▶User Interface Services
    • ▶Web Services
    • ▶Win32 API
  • ▶SDK Documentation
  • ▶DDK Documentation
  • ▶Windows Resource Kits
  • ▶Knowledge Base
  • ▶Technical Articles
  • ▶Backgrounders
  • ▶Specifications
  • ▶Books
  • ▶Partial Books
  • ▶Periodicals
  • ▶Samples