关系型DBMS的查询性能评估

[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing Pub Date : 1992-02-02 DOI:10.1109/RIDE.1992.227396

Øystein Grøvlen, Ø. Trier

{"title":"关系型DBMS的查询性能评估","authors":"Øystein Grøvlen, Ø. Trier","doi":"10.1109/RIDE.1992.227396","DOIUrl":null,"url":null,"abstract":"This paper presents a study of query performance in Oracle RDBMS. The test results show that for low selectivity selection queries, indexes are of no help. It is also shown that when joining large parts of tables, sort-merge join performs better than indexed join.<<ETX>>","PeriodicalId":138660,"journal":{"name":"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing","volume":"22 1","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"1992-02-02","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":"{\"title\":\"Query performance evaluation of a relational DBMS\",\"authors\":\"Øystein Grøvlen, Ø. Trier\",\"doi\":\"10.1109/RIDE.1992.227396\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper presents a study of query performance in Oracle RDBMS. The test results show that for low selectivity selection queries, indexes are of no help. It is also shown that when joining large parts of tables, sort-merge join performs better than indexed join.<<ETX>>\",\"PeriodicalId\":138660,\"journal\":{\"name\":\"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing\",\"volume\":\"22 1\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"1992-02-02\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"0\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1109/RIDE.1992.227396\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1109/RIDE.1992.227396","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 0

摘要

本文对Oracle RDBMS中的查询性能进行了研究。测试结果表明，对于低选择性选择查询，索引没有帮助。还表明，当连接表的大部分时，排序合并连接比索引连接执行得更好。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Query performance evaluation of a relational DBMS

This paper presents a study of query performance in Oracle RDBMS. The test results show that for low selectivity selection queries, indexes are of no help. It is also shown that when joining large parts of tables, sort-merge join performs better than indexed join.<>

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

[1992 Proceedings] Second International Workshop on Research Issues on Data Engineering: Transaction and Query Processing

自引率

0.00%

发文量