Services on Demand
Journal
Article
Indicators
- Cited by SciELO
- Access statistics
Related links
- Cited by Google
- Similars in SciELO
- Similars in Google
Share
Ingeniería e Investigación
Print version ISSN 0120-5609
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.