DocumentCode
3253099
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
fYear
1992
fDate
2-3 Feb 1992
Firstpage
223
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;
fLanguage
English
Publisher
ieee
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
Type
conf
DOI
10.1109/RIDE.1992.227396
Filename
227396
Link To Document