qualifications: about | The WHERE clause: specifying rows |
qualified names: database objects | SQL queries |
quantified comparison test | Quantified comparison test |
quantified comparison test: subqueries | Quantified comparison tests with ANY and ALL |
queries blocked on themselves: remote data access | Queries blocked on themselves |
queries: about | Query overview |
queries: access plans | Reading access plans |
queries: common table expressions | Common Table Expressions |
queries: optimization | The role of the optimizer How the optimizer works |
queries: selecting data from a table | Queries: Selecting Data from a Table |
queries: set operations | Performing set operations on query results with UNION, INTERSECT, and EXCEPT |
queries: Transact-SQL | Writing compatible queries |
query execution algorithms | Query execution algorithms |
query execution algorithms: abbreviations used in access plans | Reading access plans |
query execution algorithms: anti-semijoin | Hash antisemijoin |
query execution algorithms: block nested loops joins | Nested block join and sorted block |
query execution algorithms: Bloom filters | Bloom filter |
query execution algorithms: duplicate elimination | Duplicate elimination |
query execution algorithms: explode | Explode |
query execution algorithms: filter and pre-filter | Filter, pre-filter and hash-filter |
query execution algorithms: grouping algorithms | Grouping |
query execution algorithms: hash anti-semijoin | Hash antisemijoin |
query execution algorithms: hash distinct | Hash distinct |
query execution algorithms: hash group by | Hash group by |
query execution algorithms: hash joins | Hash join Hash semijoin Hash antisemijoin |
query execution algorithms: hash not exists | Hash antisemijoin |
query execution algorithms: hash semijoin | Hash semijoin |
query execution algorithms: IN list | IN list |
query execution algorithms: index scans | Index scans |
query execution algorithms: indexed distinct | Indexed distinct |
query execution algorithms: indexed group by | Indexed group by |
query execution algorithms: joins | Join algorithms |
query execution algorithms: locks | Lock |
query execution algorithms: merge joins | Merge join |
query execution algorithms: merge sort | Merge sort |
query execution algorithms: nested block joins | Nested block join and sorted block |
query execution algorithms: nested loops joins | Nested loops join |
query execution algorithms: nested loops semijoin | Nested loops semijoin |
query execution algorithms: ordered distinct | Ordered distinct |
query execution algorithms: ordered group by | Ordered group by |
query execution algorithms: row limits | Row limit |
query execution algorithms: semijoin | Nested loops join Nested loops semijoin Hash semijoin |
query execution algorithms: sequential table scans | Sequential table scans |
query execution algorithms: single group by | Single group by |
query execution algorithms: sorted block joins | Nested block join and sorted block |
query execution algorithms: sorting and unions | Sorting and unions |
query execution algorithms: union all | Union all |
query normalization: remote data access | Query normalization |
query optimization and execution | Query Optimization and Execution |
query parsing: remote data access | Query parsing |
query performance: reading access plans | Reading access plans |
query preprocessing: remote data access | Query preprocessing |
query results: exporting | Exporting query results |
quotation marks: Adaptive Server Enterprise | Character strings and quotation marks |
quotation marks: character strings | Character strings and quotation marks |
QUOTED_IDENTIFIER option: about | Character strings and quotation marks |
QUOTED_IDENTIFIER option: setting for Transact-SQL compatibility | Setting options for Transact-SQL compatibility |