Query performance evaluation of a relational DBMS
Øystein Grøvlen, O. Due Trier · 2003
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.>