Complex query vs. a number of simple queries
Hi,
I have a fairly complex sql query which would need to get data from 5 or 6 tables. I was wondering to split these queries into multiple simple one. However a lot of queries (around 100) would be made then.
My question now... How will this impact on performance. Will it be quicker with one complex query or is this negligible since this simple queries are very quick?
Thanks!
Subject
Views
Written By
Posted
Complex query vs. a number of simple queries
5009
June 05, 2009 02:40AM
2038
June 05, 2009 10:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.