Table of contents
- Optimizing Database Performance Overview
- Designing Federated Database Servers
- Database Design
-
Query Tuning
-
Analyzing a Query
- Graphically Displaying the Execution Plan Using SQL 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
-
Analyzing a Query
- Application Design
- Optimizing Utility and Tool Performance
- Optimizing Server Performance