The performance of relational and object-relational SQL queries when using Oracle
Francisco Javier Moreno Arboleda, Guillermo Ospina Romero, Rafael Larios Restrepo · Ingeniería e Investigación · 2005
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 behavior of relational and object-relational models is also shown.