Matches in SemOpenAlex for { <https://semopenalex.org/work/W1534029260> ?p ?o ?g. }
Showing items 1 to 84 of
84
with 100 items per page.
- W1534029260 endingPage "253" @default.
- W1534029260 startingPage "250" @default.
- W1534029260 abstract "Microsoft SQL Server was successful for many years for transaction processing and decision sup- port workloads with neither merge join nor hash join, relying entirely on nested loops and index nested loops join. How much difference do addi- tional join algorithms really make, and how much system performance do they actually add? In a pure OLTP workload that requires only record-to-record navigation, intuition agrees that index nested loops join is sufficient. For a DSS workload, however, the question is much more complex. To answer this question, we have analyzed TPC-D query perform- ance using an internal build of SQL Server with merge-join and hash-join enabled and disabled. It shows that merge join and hash join are both re- quired to achieve the best performance for decision support workloads." @default.
- W1534029260 created "2016-06-24" @default.
- W1534029260 creator A5041862671 @default.
- W1534029260 date "1999-09-07" @default.
- W1534029260 modified "2023-09-24" @default.
- W1534029260 title "The Value of Merge-Join and Hash-Join in SQL Server" @default.
- W1534029260 cites W1986353419 @default.
- W1534029260 cites W2007030756 @default.
- W1534029260 cites W2012802704 @default.
- W1534029260 cites W2033283439 @default.
- W1534029260 cites W2043934800 @default.
- W1534029260 cites W2153329411 @default.
- W1534029260 cites W2167276970 @default.
- W1534029260 cites W2169486917 @default.
- W1534029260 hasPublicationYear "1999" @default.
- W1534029260 type Work @default.
- W1534029260 sameAs 1534029260 @default.
- W1534029260 citedByCount "8" @default.
- W1534029260 countsByYear W15340292602013 @default.
- W1534029260 countsByYear W15340292602015 @default.
- W1534029260 countsByYear W15340292602018 @default.
- W1534029260 crossrefType "proceedings-article" @default.
- W1534029260 hasAuthorship W1534029260A5041862671 @default.
- W1534029260 hasConcept C114614502 @default.
- W1534029260 hasConcept C137180784 @default.
- W1534029260 hasConcept C173608175 @default.
- W1534029260 hasConcept C188805328 @default.
- W1534029260 hasConcept C191087605 @default.
- W1534029260 hasConcept C197129107 @default.
- W1534029260 hasConcept C199360897 @default.
- W1534029260 hasConcept C203570394 @default.
- W1534029260 hasConcept C2776124973 @default.
- W1534029260 hasConcept C33923547 @default.
- W1534029260 hasConcept C41008148 @default.
- W1534029260 hasConcept C5655090 @default.
- W1534029260 hasConcept C72108876 @default.
- W1534029260 hasConcept C75949130 @default.
- W1534029260 hasConcept C77088390 @default.
- W1534029260 hasConcept C99138194 @default.
- W1534029260 hasConceptScore W1534029260C114614502 @default.
- W1534029260 hasConceptScore W1534029260C137180784 @default.
- W1534029260 hasConceptScore W1534029260C173608175 @default.
- W1534029260 hasConceptScore W1534029260C188805328 @default.
- W1534029260 hasConceptScore W1534029260C191087605 @default.
- W1534029260 hasConceptScore W1534029260C197129107 @default.
- W1534029260 hasConceptScore W1534029260C199360897 @default.
- W1534029260 hasConceptScore W1534029260C203570394 @default.
- W1534029260 hasConceptScore W1534029260C2776124973 @default.
- W1534029260 hasConceptScore W1534029260C33923547 @default.
- W1534029260 hasConceptScore W1534029260C41008148 @default.
- W1534029260 hasConceptScore W1534029260C5655090 @default.
- W1534029260 hasConceptScore W1534029260C72108876 @default.
- W1534029260 hasConceptScore W1534029260C75949130 @default.
- W1534029260 hasConceptScore W1534029260C77088390 @default.
- W1534029260 hasConceptScore W1534029260C99138194 @default.
- W1534029260 hasLocation W15340292601 @default.
- W1534029260 hasOpenAccess W1534029260 @default.
- W1534029260 hasPrimaryLocation W15340292601 @default.
- W1534029260 hasRelatedWork W104450085 @default.
- W1534029260 hasRelatedWork W2015936603 @default.
- W1534029260 hasRelatedWork W2075569152 @default.
- W1534029260 hasRelatedWork W2134155667 @default.
- W1534029260 hasRelatedWork W2351527616 @default.
- W1534029260 hasRelatedWork W2355391921 @default.
- W1534029260 hasRelatedWork W2360696508 @default.
- W1534029260 hasRelatedWork W2363554557 @default.
- W1534029260 hasRelatedWork W2367917452 @default.
- W1534029260 hasRelatedWork W2370394751 @default.
- W1534029260 hasRelatedWork W2370646993 @default.
- W1534029260 hasRelatedWork W2373658069 @default.
- W1534029260 hasRelatedWork W2374581806 @default.
- W1534029260 hasRelatedWork W2380055852 @default.
- W1534029260 hasRelatedWork W2383737762 @default.
- W1534029260 hasRelatedWork W2384972132 @default.
- W1534029260 hasRelatedWork W2386202122 @default.
- W1534029260 hasRelatedWork W2390833299 @default.
- W1534029260 hasRelatedWork W211658065 @default.
- W1534029260 hasRelatedWork W2215932785 @default.
- W1534029260 isParatext "false" @default.
- W1534029260 isRetracted "false" @default.
- W1534029260 magId "1534029260" @default.
- W1534029260 workType "article" @default.