Publication detail

Testing of Oracle Database Utilization

Authors: Panuš Jan | Pirkl Josef

Year: 2010

Type of publication: článek v odborném periodiku

Name of source: International journal of applied mathematics and informatics

Publisher name: University Press

Place: London

Page from-to: 58-64

Titles:

Language	Name	Abstract	Keywords
cze	Testování využití databáze Oracle	Článek řeší vliv Oracle optimalizátoru na využití sql dotazu v databázi.	optimalizační hinty; databáze; Oracle; sql dotaz
eng	Testing of Oracle Database Utilization	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.	database; optimizer hints; SQL statement; Oracle database.

Search