• ▼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