Ingeniería e Investigación
versão impressa ISSN 0120-5609
MORENO, Francisco Javier; OSPINA ROMERO, Guillermo e LARIOS RESTREPO, Rafael. The performance of relational and object-relational SQL queries when using Oracle. Ing. Investig. [online]. 2005, vol.25, n.3, pp. 4-12. ISSN 0120-5609.
This article presents a study in which the performance of several queries involving GROUP BY clause, sub-queries (using IN and EXISTS clauses) and joins are measured and compared by means of specific queries. The behaviour of relational and object-relational models is also shown.
Palavras-chave : relational and object-relational databases; tuning; SQL; Oracle.