I have one huge complex query which I am planning of breaking in few small queries. This huge query takes a long time to execute.. It has too bad performance.
I read in some Oracle book that few small queries instead of one big can improve performance. Is this true ?
How does it make a performance improvement as these small queries will be doing the same processing as one giant query ?

Thanks a lot
Sonali