Query performance evaluation of a relational 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

引用次数: 0

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.<>

查看原文本刊更多论文

关系型DBMS的查询性能评估

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

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

求助全文

约1分钟内获得全文求助全文

来源期刊

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

自引率

0.00%

发文量