Matches in SemOpenAlex for { <https://semopenalex.org/work/W1569148339> ?p ?o ?g. }
Showing items 1 to 56 of
56
with 100 items per page.
- W1569148339 endingPage "962" @default.
- W1569148339 startingPage "952" @default.
- W1569148339 abstract "The quality of execution plans generated by a query optimizer is tied to the accuracy of its cardinality estimation. Errors in estimation lead to poor performance, erratic behavior, and user frustration. Traditionally, the optimizer is restricted to use only statistics on base table columns and derive estimates bottom-up. This approach has shortcomings with dealing with complex queries, and with rich languages such as SQL: Errors grow as estimation is done on top of estimation, and some constructs are simply not handled.In this paper we describe the creation and utilization of statistics on views in SQL Server, which provides the optimizer with statistical information on the result of scalar or relational expressions. It opens a new dimension on the data available for cardinality estimation and enables arbitrary correction. We describe the implementation of this feature in the optimizer architecture, and show its impact on the quality of plans generated through a number of examples." @default.
- W1569148339 created "2016-06-24" @default.
- W1569148339 creator A5016107143 @default.
- W1569148339 creator A5022433632 @default.
- W1569148339 creator A5059134356 @default.
- W1569148339 creator A5072322247 @default.
- W1569148339 date "2003-01-01" @default.
- W1569148339 modified "2023-09-26" @default.
- W1569148339 title "Statistics on Views" @default.
- W1569148339 cites W135863099 @default.
- W1569148339 cites W1486683419 @default.
- W1569148339 cites W1564381193 @default.
- W1569148339 cites W187851124 @default.
- W1569148339 cites W1975733288 @default.
- W1569148339 cites W2060091058 @default.
- W1569148339 cites W2136195851 @default.
- W1569148339 cites W2171492933 @default.
- W1569148339 cites W2751199251 @default.
- W1569148339 doi "https://doi.org/10.1016/b978-012722442-8/50089-6" @default.
- W1569148339 hasPublicationYear "2003" @default.
- W1569148339 type Work @default.
- W1569148339 sameAs 1569148339 @default.
- W1569148339 citedByCount "13" @default.
- W1569148339 countsByYear W15691483392012 @default.
- W1569148339 countsByYear W15691483392013 @default.
- W1569148339 countsByYear W15691483392018 @default.
- W1569148339 crossrefType "book-chapter" @default.
- W1569148339 hasAuthorship W1569148339A5016107143 @default.
- W1569148339 hasAuthorship W1569148339A5022433632 @default.
- W1569148339 hasAuthorship W1569148339A5059134356 @default.
- W1569148339 hasAuthorship W1569148339A5072322247 @default.
- W1569148339 hasConcept C105795698 @default.
- W1569148339 hasConcept C33923547 @default.
- W1569148339 hasConcept C41008148 @default.
- W1569148339 hasConceptScore W1569148339C105795698 @default.
- W1569148339 hasConceptScore W1569148339C33923547 @default.
- W1569148339 hasConceptScore W1569148339C41008148 @default.
- W1569148339 hasLocation W15691483391 @default.
- W1569148339 hasOpenAccess W1569148339 @default.
- W1569148339 hasPrimaryLocation W15691483391 @default.
- W1569148339 hasRelatedWork W2049775471 @default.
- W1569148339 hasRelatedWork W2093578348 @default.
- W1569148339 hasRelatedWork W2350741829 @default.
- W1569148339 hasRelatedWork W2358668433 @default.
- W1569148339 hasRelatedWork W2376932109 @default.
- W1569148339 hasRelatedWork W2382290278 @default.
- W1569148339 hasRelatedWork W2390279801 @default.
- W1569148339 hasRelatedWork W2748952813 @default.
- W1569148339 hasRelatedWork W2899084033 @default.
- W1569148339 hasRelatedWork W3004735627 @default.
- W1569148339 isParatext "false" @default.
- W1569148339 isRetracted "false" @default.
- W1569148339 magId "1569148339" @default.
- W1569148339 workType "book-chapter" @default.