In my experience with Oracle technology, the best performance is
always to minimize the number of queries, so if you can grab it all in
one query, that would be best!
Enjoy,
John
On Jul 27, 5:22 am, Dave Maharaj :: WidePixels.com
d...@widepixels.com wrote:
I am building a function that
I am building a function that checks access permission. First check if
profile is public, if not conditions from 2 other tables are checked and 1
of those conditions must be true to allow access.
My question is should i just grab all the conditions needed to be checked
with 1 query then compare