Title :
Query performance evaluation of a relational DBMS
Author :
GrØvlen, Øystein ; Trier, Ø0ivind Due
Author_Institution :
Div. of Comput. Syst. & Telematics, Norwegian Inst. of Technol., Trondheim, Norway
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
Keywords :
performance evaluation; query processing; relational databases; Oracle; indexes; low selectivity selection queries; query performance evaluation; relational DBMS; sort-merge join; tables; Application software; Databases; Meteorology; Radio access networks; Read-write memory; Telematics; Testing;
Conference_Titel :
Research Issues on Data Engineering, 1992: Transaction and Query Processing, Second International Workshop on
Conference_Location :
Tempe, AZ
Print_ISBN :
0-8186-2660-7
DOI :
10.1109/RIDE.1992.227396
