[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] queries 2nd [See also distributed queries] ad hoc central publisher scenario adhoc, Profiler 2nd Analysis Manager 2nd column expressions subqueries data-driven 2nd EXPLICIT, XML indexes and large databases 2nd 3rd min memory per query, configuration 2nd performance, views and 2nd 3rd 4th Profiler and query plan automatic recompilation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th minimizing 2nd 3rd 4th 5th 6th 7th monitoring 2nd 3rd 4th query plan forced recompilation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th run time datediff ( ) function 2nd 3rd 4th 5th shared-query plans, stored procedures 2nd 3rd 4th 5th 6th stored procedures caching and 2nd subqueries T-SQL 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th syslockinfo table 2nd 3rd 4th system tables information schema views 2nd 3rd metadata functions system functions system stored procedures 2nd URL XML and 2nd 3rd 4th 5th query analysis join clauses OR clauses 2nd 3rd search arguments 2nd 3rd 4th 5th 6th 7th 8th 9th subqueries 2nd 3rd 4th Query Analyzer 2nd 3rd 4th Client Statistics 2nd Clustered Index 2nd 3rd 4th configuration files connections 2nd datediff( ) function 2nd 3rd 4th 5th Eager spool execution plans 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th ToolTips 2nd 3rd 4th 5th 6th 7th 8th Filter operator function creation 2nd 3rd functions modifying 2nd 3rd 4th 5th 6th viewing 2nd 3rd 4th 5th 6th hash joins 2nd 3rd hash matches Index Spool icon 2nd Index Tuning Wizard Inserted Scan operator Lazy spool Log Row Scan icon logical operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th merge joins nested loops Object Browser 2nd 3rd 4th 5th Object Search tool overview 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th Parameter Table Scan icon physical operators 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th query analysis 2nd Query Editor 2nd query execution 2nd 3rd 4th query results 2nd 3rd 4th Remote Delete operator Remote Query operator Remote Scan operator Remote Update operator Row Count Spool icon scripts templates 2nd 3rd 4th Sequence operator Server Trace 2nd SET STATISTICS PROFILE option 2nd shortcuts 2nd Sort operator statistics 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th STATISTICS IO option 2nd 3rd 4th 5th 6th 7th 8th STATISTICS TIME option 2nd 3rd 4th 5th 6th 7th stored procedures 2nd 3rd 4th debugging 2nd 3rd 4th 5th source code 2nd 3rd 4th Stream Aggregate operator T-SQL Debugger 2nd 3rd 4th 5th 6th 7th 8th 9th 10th common problems 2nd 3rd 4th 5th 6th Table Delete operator Table Insert operator Table Scan operator Table Spool icon Table Update Top operator user -defined tools 2nd 3rd Windows 98 and Windows Me Query Analyzer, Enterprise Manager Query Analzyer Compute Scalar operator Concatenation operator Constant Scan operator 2nd Deleted Scan operator Split physical operator query compilation 2nd DML statements Query Designer 2nd DTS Designer and Query Editor 2nd query governor cost limit, configuration 2nd 3rd query optimization common problems 2nd 3rd 4th 5th 6th 7th 8th 9th data warehousing 2nd 3rd DISTINCT execution plan selection 2nd 3rd 4th 5th 6th GROUP BY optimization 2nd 3rd index selection 2nd 3rd cost estimation 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th indexed views 2nd 3rd 4th 5th 6th join selectivity 2nd 3rd 4th multiple indexes 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th SARG selectivity 2nd 3rd 4th join selection 2nd processing strategies 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th join selection and parallel processing 2nd 3rd 4th 5th 6th 7th 8th predicate transitivity 2nd 3rd query analysis 2nd join clauses OR clauses 2nd 3rd search arguments 2nd 3rd 4th 5th 6th 7th 8th 9th subqueries 2nd 3rd 4th query plans, reusing 2nd 3rd 4th 5th 6th 7th 8th 9th UNION 2nd query optimizer BCP utility and query optimizers changing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th optimization steps 2nd overview 2nd query performance, indexes 2nd 3rd 4th 5th 6th query plans, reusing 2nd 3rd 4th 5th 6th 7th 8th 9th query wait, configuration Queue Reader Agent updating subscribers and |