The following information was submitted:
Transactions: INTERNATIONAL JOURNAL of APPLIED MATHEMATICS AND INFORMATICS
Transactions ID Number: 19-635
Full Name: Jan Panus
Position: Lecturer
Age: ON
Sex: Male
Address: Studentska 95, Pardubice 53210
Country: CZECH REPUBLIC
Tel:
Tel prefix:
Fax:
E-mail address: jan.panus@upce.cz
Other E-mails:
Title of the Paper: Testing of Oracle database utilization
Authors as they appear in the Paper: Jan Panus Josef Pirkl
Email addresses of all the authors: jan.panus@upce.cz, jpirkl@seznam.cz
Number of paper pages: 8
Abstract: This paper deals with the influence of the Oracle Optimizer hints (sql hints) usage on the query execution. It is the part of parallel computing for data storage as the result of parallel computing. We test the comparison of the classic SQL queries execution towards SQL queries which use Oracle hints. It also examines how the efficiency is influenced by the presence of indices when using hints, how the hints behave when connecting several tables in a query and how the hints are influenced by the chosen Oracle optimizer mode. The CPU time is the basic criterion for the assessment of the efficiency
Keywords: Database, Optimizer hints, SQL statement, Oracle database, Statistics
EXTENSION of the file: .pdf
Special (Invited) Session: Influence of Oracle hints on query execution
Organizer of the Session: 635-517
How Did you learn about congress: Pavel Jirava - pavel.jirava@upce.cz
IP ADDRESS: 195.113.126.171
