Abstract

MORENO, Francisco Javier; OSPINA ROMERO, Guillermo  and  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.

Keywords : relational and object-relational databases; tuning; SQL; Oracle.

        · abstract in Spanish     · text in Spanish     · Spanish ( pdf )